Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re^15: SQL query using elements from array

by mje (Curate)
on Oct 29, 2014 at 17:00 UTC ( #1105510=note: print w/replies, xml ) Need Help??


in reply to Re^14: SQL query using elements from array
in thread SQL query using elements from array

Yes, my mistake, sorry, it does in fact look like it is a datetime and a datetime in MS SQL Server is compatible with an ODBC quoted ts.

However, it appears I've somewhat mislead you. The SQL Server driver I use does accept ODBC timestamp escapes in bound parameters whereas the MS one appears not to. So, if you are using the ODBC escapes with your driver you'd need to concatenate them into your SQL or pass them as plain timestamp strings in a format MS accepts.

  • Comment on Re^15: SQL query using elements from array

Replies are listed 'Best First'.
Re^16: SQL query using elements from array
by AllPaoTeam (Acolyte) on Nov 03, 2014 at 19:47 UTC
    OK, thanks I will try that, once again thank you for all your time and effort!

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (3)
As of 2019-04-22 08:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I am most likely to install a new module from CPAN if:
















    Results (112 votes). Check out past polls.

    Notices?