silly error
-
iam using ms-access database and iam inserting a query into ms-access memo field
query is
insert into search(empid,query,queryname) values('20054','SELECT candidatesRegistration.firstname, candidatesRegistration.lastname, candidatesRegistration.university FROM candidatesRegistration where 1=1 and ((candidatesRegistration.industryid)=68) and ((candidatesRegistration.jobcategoryid)=1) and ((candidatesRegistration.specialisationid)=17) and ((candidatesRegistration.designation) like '%pr%') and ((candidatesRegistration.education) like '%highdegree%') and ((candidatesRegistration.certifications) like '%certi%') and ((candidatesRegistration.university) like '%mumbai%') and ((candidatesRegistration.countryid)=1) and ((candidatesRegistration.stateid)=25) and ((candidatesRegistration.keywords)like '%vb,asp%') and ((candidatesRegistration.cityid)='251')','querymade')
how to insert a data with " ' " in the data, i tried to replace it with " ' ' "
it diddnt work
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
-
Not too sure what you're trying to achieve. Are you wanting to store the query text in a field, or the results from that query?
You can use the replace function to replace the single quotes with double quotes, or any other character for that matter
eg: replace('select blah, blah...', '''', '''''')
The trick is to include two quotes for every single quote.
--------------------
Colt 45 - the original point and click interface
-
i tried replaceing singles quotes with double quotes but it still gives me error
iam trying to store a query in a memo field
query is made dynamically based on user selection
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
-
thank you , the problem is solved, problem was some where else, silly mistake it was
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply