Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: Invalid Query Characters


Message #1 by "Meredith Shaebanyan" <merediths@p...> on Thu, 5 Apr 2001 09:19:50 -0700

	Does anybody have a list of characters that are invalid in Access97? I'm

taking user input from a webform, and it keeps breaking and throwing an odbc

error. So far, I'm replacing the single quote (') and hyphen (-) .... maybe

somebody has a custom function they've coded up that they'd be willing to

send the list? From asp, I'm doing a:



	str = Request.Form("blah")

	str = replace(str, "'", "''")

	str = replace(str, "-", " ")

	objRS("blah") = str



	what I'd like to do is:



	objRS = myFunction(Request.Form("blah")



	And have all the parsing done in myFunction. That way, I could also add in

some web-specific stuff, like getting rid of all the html tags.



	-- Meredith Shaebanyan






  Return to Index