Stuck on replace command

[TRACEYMARYLAND]

I have this
BLOWER_SERIAL_NUMBER = rtrim(request.form("BLOWER_SERIAL_NUMBER"))
BLOWER_SERIAL_NUMBER = replace(BLOWER_SERIAL_NUMBER,"'", "''")


My replace is giving me a syntax error
I cannot figure it out

 

[Lothario]

be careful Replace or trim functions throw errors when the field is null

so check for nulls...something like this

if BLOWER_SERIAL_NUMBER <>"" then
BLOWER_SERIAL_NUMBER = replace(BLOWER_SERIAL_NUMBER,"'", "''")
end if

-L

 

[Lothario]

actually u can do this too...

if request.form("BLOWER_SERIAL_NUMBER") <>"" then
BLOWER_SERIAL_NUMBER = replace(rtrim(request.form("BLOWER_SERIAL_NUMBER")),"'", "''")
end if

-L

 

[Genimuse]

It's also worth noting that you may want to use the full Trim() function rather than just RTrim(), since you probably don't want spaces at the beginning, either.

 

[snowboardr]

Actually its best not to use Request.Form twice on the same object you should dump them into a String first then use the string.

www.sitesd.com
ASP WEB DEVELOPMENT

 

[TRACEYMARYLAND]

Oh i did not know about the null...or full trim

Thanks......to all of you.

 

[TRACEYMARYLAND]

full trim...what the command for that i can only
see ltrim or rtrim

cheers

 

[Lothario]

just use trim without l or r

-L