Click here to Skip to main content
15,905,028 members
Home / Discussions / C#
   

C#

 
GeneralRe: ODBC Type mismatch error Pin
Luc Pattyn26-Oct-09 12:22
sitebuilderLuc Pattyn26-Oct-09 12:22 
GeneralRe: ODBC Type mismatch error Pin
TheJudeDude26-Oct-09 13:19
TheJudeDude26-Oct-09 13:19 
GeneralRe: ODBC Type mismatch error Pin
Luc Pattyn26-Oct-09 13:40
sitebuilderLuc Pattyn26-Oct-09 13:40 
GeneralRe: ODBC Type mismatch error Pin
TheJudeDude26-Oct-09 14:10
TheJudeDude26-Oct-09 14:10 
GeneralRe: ODBC Type mismatch error Pin
Luc Pattyn26-Oct-09 14:18
sitebuilderLuc Pattyn26-Oct-09 14:18 
GeneralRe: ODBC Type mismatch error Pin
TheJudeDude26-Oct-09 14:42
TheJudeDude26-Oct-09 14:42 
GeneralRe: ODBC Type mismatch error Pin
Luc Pattyn26-Oct-09 14:53
sitebuilderLuc Pattyn26-Oct-09 14:53 
GeneralRe: ODBC Type mismatch error Pin
TheJudeDude26-Oct-09 15:41
TheJudeDude26-Oct-09 15:41 
Thank you so much for your help!
But...here is the report:
Single quotes, '10/25/2009' returns an error of Type Mismatch in WHERE clause, value '10/25/2009'

A pound around the date returns an error of Syntax Error: Required text missing. Next token '#'

The ` character around the date returns the same as the previous. (thought this was the one that would work due to using ` in bash scripting and this being a *nix server)

Using the DateTime field dtProcDate by itself returns an error of Unprocessed input. Next token '8' (which is the hour of the day)
Doing the same on >= would yield the same result.

The data is updated daily at midnight local time, so the data is static for the date used.

And all is set in a try/catch.


These pretzels are making me thirsty!

Jude

GeneralRe: ODBC Type mismatch error Pin
Luc Pattyn26-Oct-09 15:46
sitebuilderLuc Pattyn26-Oct-09 15:46 
GeneralRe: ODBC Type mismatch error Pin
TheJudeDude27-Oct-09 3:49
TheJudeDude27-Oct-09 3:49 
AnswerRe: ODBC Type mismatch error Pin
Luc Pattyn26-Oct-09 10:05
sitebuilderLuc Pattyn26-Oct-09 10:05 
QuestionChecking required fields in a second Windows Form Pin
JTRizos26-Oct-09 8:31
JTRizos26-Oct-09 8:31 
AnswerRe: Checking required fields in a second Windows Form Pin
Not Active26-Oct-09 8:50
mentorNot Active26-Oct-09 8:50 
GeneralRe: Checking required fields in a second Windows Form Pin
JTRizos26-Oct-09 11:09
JTRizos26-Oct-09 11:09 
GeneralRe: Checking required fields in a second Windows Form Pin
Not Active26-Oct-09 11:26
mentorNot Active26-Oct-09 11:26 
GeneralRe: Checking required fields in a second Windows Form Pin
JTRizos26-Oct-09 11:56
JTRizos26-Oct-09 11:56 
GeneralRe: Checking required fields in a second Windows Form Pin
Not Active26-Oct-09 12:44
mentorNot Active26-Oct-09 12:44 
GeneralRe: Checking required fields in a second Windows Form Pin
JTRizos26-Oct-09 13:03
JTRizos26-Oct-09 13:03 
GeneralRe: Checking required fields in a second Windows Form Pin
CodyDaemon29-Oct-09 5:54
CodyDaemon29-Oct-09 5:54 
GeneralRe: Checking required fields in a second Windows Form Pin
JTRizos29-Oct-09 6:24
JTRizos29-Oct-09 6:24 
AnswerRe: Checking required fields in a second Windows Form Pin
_Madmatt26-Oct-09 9:43
_Madmatt26-Oct-09 9:43 
GeneralRe: Checking required fields in a second Windows Form Pin
Not Active26-Oct-09 9:59
mentorNot Active26-Oct-09 9:59 
GeneralRe: Checking required fields in a second Windows Form Pin
_Madmatt27-Oct-09 9:45
_Madmatt27-Oct-09 9:45 
GeneralRe: Checking required fields in a second Windows Form Pin
Not Active27-Oct-09 10:10
mentorNot Active27-Oct-09 10:10 
GeneralRe: Checking required fields in a second Windows Form Pin
_Madmatt27-Oct-09 10:20
_Madmatt27-Oct-09 10:20 

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.