Click here to Skip to main content
15,916,030 members
Home / Discussions / Web Development
   

Web Development

 
GeneralRe: Sending Form from HTML Webpage Pin
Not Active8-Apr-10 12:25
mentorNot Active8-Apr-10 12:25 
GeneralRe: Sending Form from HTML Webpage Pin
Dalek Dave8-Apr-10 12:32
professionalDalek Dave8-Apr-10 12:32 
GeneralRe: Sending Form from HTML Webpage Pin
Dalek Dave8-Apr-10 14:02
professionalDalek Dave8-Apr-10 14:02 
AnswerRe: Sending Form from HTML Webpage Pin
daveyerwin8-Apr-10 13:52
daveyerwin8-Apr-10 13:52 
GeneralRe: Sending Form from HTML Webpage Pin
Dalek Dave8-Apr-10 14:01
professionalDalek Dave8-Apr-10 14:01 
GeneralRe: Sending Form from HTML Webpage Pin
Not Active8-Apr-10 14:27
mentorNot Active8-Apr-10 14:27 
Questionhow to insert special characters into database msacess using asp Pin
rajivkadam4207-Apr-10 19:41
rajivkadam4207-Apr-10 19:41 
AnswerRe: how to insert special characters into database msacess using asp Pin
Gregory Gadow8-Apr-10 4:06
Gregory Gadow8-Apr-10 4:06 
It depends on how you are inserting the data. If the SQL ends up looking like
INSERT MyTable (FirstName, LastName) VALUES ('Charles', 'O'Banion')

you will have a problem as the auto-formatting shows: the apostrophe in the last name gets treated as a delimiter, causing the insert to fail with a syntax error.

What you need to do is use parameters to pass the data into your database. I am not sure of how to do this in DAO, it has been a VERY long time since I've written anything for Access. You can probably find the how-to very easily, though.

Keep in mind that allowing special characters like single quotes and the wildcard characters *, ? and # might cause problems latter if you want to use LIKE to search for those characters. For example,
SELECT * FROM MyTable WHERE Password LIKE 'hot*shot'

would return every record where Password starts with "hot" and ends with "shot", with any number of characters in between. You will need to figure out whether the splat is a wildcard or a literal and, if it is a literal, wrap it in square brackets so the actual statement becomes
SELECT * FROM MyTable WHERE Password LIKE 'hot[*]shot'

This tells Access to treat the splat as a literal and not as a wildcard. I am not sure if parameter fields will treat wildcard characters as wildcards or literals in this case. You can also avoid the problem entirely by not using LIKE;
SELECT * FROM MyTable WHERE Password = 'hot*shot'

will work as expected.
QuestionLaunch an application from Classic ASP Pin
Member 45264877-Apr-10 17:20
Member 45264877-Apr-10 17:20 
AnswerRe: Launch an application from Classic ASP Pin
daveyerwin8-Apr-10 1:05
daveyerwin8-Apr-10 1:05 
AnswerRe: Launch an application from Classic ASP Pin
Not Active8-Apr-10 1:44
mentorNot Active8-Apr-10 1:44 
QuestionProblem with jquery.ajax result - auto replaced chars and enclosed in XML - Why ??? Pin
Stephan Pilz7-Apr-10 4:25
Stephan Pilz7-Apr-10 4:25 
AnswerRe: Problem with jquery.ajax result - auto replaced chars and enclosed in XML - Why ??? Pin
daveyerwin7-Apr-10 5:18
daveyerwin7-Apr-10 5:18 
JokeRe: Problem with jquery.ajax result - auto replaced chars and enclosed in XML - Why ??? Pin
T M Gray7-Apr-10 8:51
T M Gray7-Apr-10 8:51 
GeneralRe: Problem with jquery.ajax result - auto replaced chars and enclosed in XML - Why ??? Pin
Stephan Pilz7-Apr-10 9:09
Stephan Pilz7-Apr-10 9:09 
GeneralRe: Problem with jquery.ajax result - auto replaced chars and enclosed in XML - Why ??? Pin
daveyerwin7-Apr-10 10:07
daveyerwin7-Apr-10 10:07 
GeneralRe: Problem with jquery.ajax result - auto replaced chars and enclosed in XML - Why ??? Pin
T M Gray7-Apr-10 10:07
T M Gray7-Apr-10 10:07 
GeneralRe: Problem with jquery.ajax result - auto replaced chars and enclosed in XML - Why ??? Pin
Stephan Pilz7-Apr-10 10:25
Stephan Pilz7-Apr-10 10:25 
GeneralRe: Problem with jquery.ajax result - auto replaced chars and enclosed in XML - Why ??? Pin
T M Gray7-Apr-10 10:44
T M Gray7-Apr-10 10:44 
GeneralRe: Problem with jquery.ajax result - auto replaced chars and enclosed in XML - Why ??? Pin
daveyerwin7-Apr-10 10:50
daveyerwin7-Apr-10 10:50 
Questionhow to make a link to facebook? Pin
bigeyed6-Apr-10 3:33
bigeyed6-Apr-10 3:33 
AnswerRe: how to make a link to facebook? Pin
Dalek Dave6-Apr-10 11:54
professionalDalek Dave6-Apr-10 11:54 
QuestionUnable to run Tomcat6.0 server on Eclipse3.4 Pin
Ram Bonala5-Apr-10 23:37
Ram Bonala5-Apr-10 23:37 
AnswerRe: Unable to run Tomcat6.0 server on Eclipse3.4 Pin
Garth J Lancaster6-Apr-10 0:07
professionalGarth J Lancaster6-Apr-10 0:07 
QuestionCustom error pages .Net [modified] Pin
markymark825-Apr-10 22:44
markymark825-Apr-10 22:44 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.