Setting value of input from SQL database to edit

[=?Utf-8?B?RXBvaCBSaW8=?=]

Hi, I am trying to create a way to edit data in a database.

Response.Write ("<input name=""issue"" value=" & recSet.Fields(" Name") & """

></td></tr>")

If the name contains a space (i.e. first and last name)

It only displays the first name (because of the space)

I have tried several things to get this to work

Works: Response.Write (recSet.Fields( "Name"))

But I can't (even if I store the data as a variable) get it to display the
full name.

Any ideas????

Thanks,

[=?Utf-8?B?RXBvaCBSaW8=?=]

RE: Setting value of input from SQL database to edit

Never mind I found it. It was putting in there I just had bad html

"Epoh Rio" wrote:

Hi, I am trying to create a way to edit data in a database.
>
Response.Write ("<input name=""issue"" value=" & recSet.Fields(" Name") & """

</td></tr>")

>
If the name contains a space (i.e. first and last name)
>
It only displays the first name (because of the space)
>
I have tried several things to get this to work
>
Works: Response.Write (recSet.Fields( "Name"))
>
But I can't (even if I store the data as a variable) get it to display the
full name.
>
Any ideas????
>
Thanks,