Click here to Skip to main content
12,241,599 members (56,673 online)
   

Database

 
AnswerRe: No new tables in database after executed query Pin
JammoD8710-May-13 22:36
memberJammoD8710-May-13 22:36 
GeneralRe: No new tables in database after executed query Pin
Member 991209111-May-13 4:51
memberMember 991209111-May-13 4:51 
QuestionER Diagramming Tools - which one to use Pin
ole.Grossklaus@gmx.de10-May-13 3:37
memberole.Grossklaus@gmx.de10-May-13 3:37 
AnswerRe: ER Diagramming Tools - which one to use Pin
Jörgen Andersson12-May-13 9:01
professionalJörgen Andersson12-May-13 9:01 
NewsNew Built-In functions in 2012 Pin
Karthik_J, Coimbatore10-May-13 3:24
memberKarthik_J, Coimbatore10-May-13 3:24 
GeneralRe: New Built-In functions in 2012 Pin
Richard MacCutchan10-May-13 5:05
mvpRichard MacCutchan10-May-13 5:05 
GeneralRe: New Built-In functions in 2012 Pin
jschell10-May-13 9:00
memberjschell10-May-13 9:00 
QuestionCannot Find Rows With % character in Text Fields with Access SQL Pin
JohnBlocker8-May-13 11:01
memberJohnBlocker8-May-13 11:01 
I am using an Access 2000 database file. When parsing user input that has SQL reserved characters, I put [] around any reserved characters I find. This works fine, except when dealing with %s.

I have a table named "Foo", with two rows:
Type as text, SubType as text, with two rows of values:

"Sales Tax (%)", "NY"
"Sales Tax (%)", PA"

When I execute the following:
SELECT * From Foo WHERE Type LIKE '%Sales Tax ([%])%'

I get the rows returned I expect, where the row has a value in the Type column of "Sales Tax (%)"

But when I execute:
SELECT * From Foo WHERE Type = 'Sales Tax ([%])'

No rows are returned

Even if I omit the parenthesis around the % sign, it does not find the rows.

Is there something odd I am doing wrong, perhaps specific to Access SQL?
AnswerRe: Cannot Find Rows With % character in Text Fields with Access SQL Pin
Jörgen Andersson9-May-13 10:34
professionalJörgen Andersson9-May-13 10:34 
GeneralRe: Cannot Find Rows With % character in Text Fields with Access SQL Pin
JohnBlocker9-May-13 23:15
memberJohnBlocker9-May-13 23:15 
GeneralRe: Cannot Find Rows With % character in Text Fields with Access SQL Pin
Jörgen Andersson10-May-13 5:51
professionalJörgen Andersson10-May-13 5:51 
AnswerRe: Cannot Find Rows With % character in Text Fields with Access SQL Pin
Richard Deeming10-May-13 2:39
professionalRichard Deeming10-May-13 2:39 
AnswerRe: Cannot Find Rows With % character in Text Fields with Access SQL Pin
jschell10-May-13 9:02
memberjschell10-May-13 9:02 
AnswerRe: Cannot Find Rows With % character in Text Fields with Access SQL Pin
Fabricio Dos Santos Antunes10-May-13 16:22
memberFabricio Dos Santos Antunes10-May-13 16:22 
Questionrule of DataAdapter Pin
messages7-May-13 22:10
membermessages7-May-13 22:10 
AnswerRe: rule of DataAdapter Pin
PIEBALDconsult8-May-13 5:59
professionalPIEBALDconsult8-May-13 5:59 
GeneralRe: rule of DataAdapter Pin
messages8-May-13 9:47
membermessages8-May-13 9:47 
GeneralRe: rule of DataAdapter Pin
PIEBALDconsult9-May-13 5:35
professionalPIEBALDconsult9-May-13 5:35 
GeneralRe: rule of DataAdapter Pin
messages9-May-13 6:16
membermessages9-May-13 6:16 
Questiondifference between with and temp table in my two query Pin
mehdi.sabet7-May-13 10:02
groupmehdi.sabet7-May-13 10:02 
AnswerRe: difference between with and temp table in my two query Pin
Eddy Vluggen7-May-13 10:40
mvpEddy Vluggen7-May-13 10:40 
AnswerRe: difference between with and temp table in my two query Pin
Jörgen Andersson8-May-13 12:52
professionalJörgen Andersson8-May-13 12:52 
AnswerRe: difference between with and temp table in my two query Pin
Fabricio Dos Santos Antunes10-May-13 15:55
memberFabricio Dos Santos Antunes10-May-13 15:55 
QuestionExport Image from SQL to png Format Pin
mrfalk7-May-13 9:09
membermrfalk7-May-13 9:09 
AnswerRe: Export Image from SQL to png Format Pin
Eddy Vluggen7-May-13 10:52
mvpEddy Vluggen7-May-13 10:52 

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.


Advertise | Privacy | Mobile
Web02 | 2.8.160426.1 | Last Updated 29 Apr 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid