I am querying a database using an e-mail deal with. The tackle is certainly like fred.o'[email protected]
In Delphi that appears like 'fred.o'[email protected]' as the apostrophe can be escaped of training course.
Statements to execute. You can set the SQL property's value via the Object Inspector at design time or through code at runtime. Query Component in Delphi.
Allow's state the query is certainly
today if I just substitute %t the query falls flat as it seems to discover the value as 2 guitar strings 'fred.u' and '[email protected]'. we.elizabeth. it doesn't recognize the escape.
if the query is certainly
and the parameter is usually fixed to the email deal with it works if there is usually no apostrophe but doesn't match up the information if teh email address consists of one
modified to get rid of incorrect data
Any suggestions?
Russell Weetch
Russell WeetchRussell Weetch
shutas off-topic by Bhargav Rao♦Jan 2 '17 at 5:32
This query shows up to be off-topic. The customers who voted to near gave this specific reason:
- 'This question was caused bya issue that can no longer become producedora easy typographical mistake. While comparable questions may be on-topic here, this a single was resolved in a way unlikely to assist future visitors. This can usually be avoided by identifying and closely inspecting the shortest program necessary to recreate the problem before publishing.' - Bhargav Rao
1 Reply
When using parameters, perform not add the estimates or get away anything yourself.
This should function:
If it'beds not returning anything, verify the actual ideals that are usually stored in the database. It may have not happen to be escaped properly when it had been placed.
Marcus AdamsMarcus Adams44k88 platinum badges6767 silver badges122122 bronze badges