I am trying to save a School Name. St Paul's Secondary.<BR>Upon inserting to database, it is giving me error.<BR>Data field type is varchar.<BR><BR>Thanks
Cannot read solution suggested. Can you repost, please. I had tried to do a Cstr but it is not working.
Read the FAQs<BR><BR>
I used replace(cstr(request.form("schName")), "'", "''")
...the CSTR is a waste of code. *ALL* values you get from <BR> Request.Form("xxx")<BR>are *always* strings. So CSTR doesn't do anything.<BR><BR>
That would be what we call 'reading the FAQ', then?<BR><BR>apart from the needless cast, of course.