Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re: DBD::ODBC / ACCESS-SQL incompliancy

by VSarkiss (Monsignor)
on Oct 17, 2006 at 15:26 UTC ( #578815=note: print w/ replies, xml ) Need Help??


in reply to DBD::ODBC / ACCESS-SQL incompliancy

You probably have a copy-and-paste error, because even in Access that shouldn't run: you've got an unmatched single quote at the end. You probably meant this:

SELECT * FROM TBLDATA WHERE ([Event Date] LIKE '8/08/2006*');
The question then is, what data type is [Event Date]? If you're storing the date as a string, then you need to match the string format exactly. Otherwise, if you're storing it as a date, you should be able to do it with the funny Access hash-quotes:
SELECT * FROM TBLDATA WHERE ([Event Date] = #8/08/2006#);
If that doesn't work you may want to try canonical ODBC date format: '2006-aug-08'. It's hard to say without knowing more about the database and the code.


Comment on Re: DBD::ODBC / ACCESS-SQL incompliancy
Select or Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://578815]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (6)
As of 2014-12-28 22:48 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (183 votes), past polls