Hi mr dparsons

Can you please explain to me short "string literals" and

in my database i have ,text, and ,checkboxes, how do i treat this last ones after VALUES for " Your INSERT will need to be something like INSERT INTO TABLE(<columns you want to insert data into>)VALUES(" Request.Form("name") &"," & request.Form("tradingas")) etc etc etc."

Is this as binding alright 1: <%=(Recordset1.Fields.Item("name").Value)%> 2: <%=(Recordset1.Fields.Item("tradingas").Value)%> ,

and one checkbox binding sample : <%If (CStr((Recordset1.Fields.Item("cc").Value)) = CStr("1")) Then Response.Write("checked=""checked""") : Response.Write("")%>

Is this right sir.

I am not sure if this was the correct way to explain it but my question actuele is : How do i put a checkbox as VALUE

Thanks in advance

NB I wish you a very nice weekend.

[email protected]

First, string literals. String literals is any text that you are inserting into a database so the string:

I am a Programmer

Would look like this in an insert:

INSERT INTO table(sometextcolumn)Values('I am a Programmer')

however, in code you will mostly be working with variables and such so it might look like this:

Dim sText
sText = "I am a Programmer"

INSERT INTO table(sometextcolumn)Values('" &sText & "')

Checkbox values. These are nothing more then bit values, 0 being off 1 being on so if you are pulling that data from your database this logic:

<%If (CStr((Recordset1.Fields.Item("cc").Value)) = CStr("1")) Then Response.Write("checked=""checked""") : Response.Write("")%>

Should be correct.

================================================== =========
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========

Hi mr. dparsons,

The script <%If (CStr((Recordset1.Fields.Item("cc").Value)) = CStr("1")) Then Response.Write("checked=""checked""") : Response.Write("")%>

has been put there by Dreamweaver.
This should be alright to PULL from the database you say.
My question is this the same to PUT into the database, since it came from the
SELECT statement.

THX

oh one other thing mr.

INSERT INTO table(sometextcolumn)Values('I am a Programmer')

I am not sure to understand this one, i have a asp page i have a database

poeple on the net should fill in on the page de details go are going to be

INSERT in to the database Record after Rekord.

Unless 'i am a programmer' is the name of a row or am i wrong here mr..

THX

the details who are going to be

sorry for that

Please excuse any condensending tone that you may gather from this post as their is none intended. I do not mind helping people on the forums but i understand that the people that are posting questions have at least beginner knowledge of the subject they are posting on and, moreover, they understand the concepts of that particular subject. To that end, I think maybe you should pick up a few books on ASP (Wrox has some good ones) as I think you are not very familiar with the language at all.

Secondly, LEARN how to code. I understand that you are using the tools available to your (Dreamweaver) but you arent learning anything and that becomes extremely important in situations like this; you didn't write the code so you don't know how to trouble shoot it.

Lastly: INSERT INTO table(sometextcolumn)Values('I am a Programmer') that was an example of a string literal being inserred into your database, it was not meant to be a functional piece of code that you could use in your application.

To PUT (aka INSERT) the checkbox value into a database you would do INSERT INTO table(cc)Values(" & Request.Form("checkbox") &")"

Checkbox here is the name of your form element that is a checkbox.



================================================== =========
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========

Hi Mr.dparsons

Thanks for the info you give to me,

I looked at maybe something i could download who could help me with Dreamweaver and i found a Book 'Foundation ASP for Dreamweaver' by Omar Elbaga and Rob Turnbull.

Only on page 9 of the book i found out that indeed it is posseble to use a
INSERT from within Dreamweaver, something i did not see because i was blindly
using SELECT without looking further into the program.

I am going to study this book seriously and i hope maybe in a later stage i could keepon looking for you'r professionale opinion buth than in other matters.

Thanks for everything.

:)

http://www.ithighway.co.uk/

Hi Mr.dparsons

I was wondering if you are still availeble and/or arround.
I did manage to make a register.asp page working, if you want http://www.business-youthlink.co.za.
My question to you Sir: the database that i use is strait forward, i should be able to demand on the page Province,preSet Type of business and gender also should be a criteria.
To make the pages with this criteria, i think i can do.
How do i stucture my database (mdb) in order to be able to do a 'search' in the database in a later stage.
For example 6monts down the line i need to now how many poeple from gauten did register and from gauteng how many, for xsample, IT people did register.
I also should be able to search for all the IT people in all provinces.

I hope you understand my question.

Thanks in advance Mr.

tagaroe
[email protected]

In access, I am not sure. You are probably going to have to write a Query that will search through your necessary tables.

In SQL Server I would write a stored procedure that would search my database where the entered criteria was found and return those rows.

Lastly, how you structure it is up to you. Are you going to need to search on more then 1 table? Will you be able to join both of those tables together?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========