Quick ASP/MySQL helpneeded.

fletch · 09-12-2008 04:06PM #1

I have a simple form that inserts into a database. That works fine. I also have a webpage that displays the contents of the database. However, when I use the value of one of the database fields as the value of an input, if the user has entered more than one word, only the first word displays.

So if the address value is say, 1 main street

This will only display the 1 in the address
Response.write "<input name=""address1"" value=" & Recordset("address1") &">"

however this will display the full address
Response.write "<td>" & Recordset("address1") & "</td> "

kayos · 09-12-2008 04:15PM

Try
Response.write "<input name=’address1’ value=’" & Recordset("address1") & "’>"

fletch · 09-12-2008 04:23PM

kayos wrote: »

Try
Response.write "<input name=’address1’ value=’" & Recordset("address1") & "’>"

Sorted it, thanks a million!!! :pac::pac::pac: Much appreciated

fletch · 10-12-2008 03:01PM

Need a bit more help. Inverted comma's in names/address seem to be breaking it.

Example the address "2 O'Callaghans Wood"

This will display 2 O in the address input
Response.write "<input name='address1' value='" & Recordset("address1") & "'>"

however this will display the full address
Response.write " & Recordset("address1") & "

nialo · 10-12-2008 03:11PM

I usually use a find replace function on the recordset to remove this char and replace is it '. tis will take care of the problem i think.

fletch · 10-12-2008 03:21PM

nialo wrote: »

I usually use a find replace function on the recordset to remove this char and replace is it '. tis will take care of the problem i think.

Once again boards to the rescue, I was replacing all instances of ' with '', replacing it with an ' as you suggest and it works fine!

Thanks a million!

nialo · 10-12-2008 04:10PM

no worries.

some of the common characters ive had issues with and what there html match is.

" -> "
' -> '
& -> &

Quick ASP/MySQL helpneeded.

Comments