Click here to Skip to main content
15,882,886 members
Home / Discussions / C#
   

C#

 
GeneralRe: ODBC Type mismatch error Pin
TheJudeDude26-Oct-09 11:51
TheJudeDude26-Oct-09 11:51 
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 
if all documentation were missing, I would try a few experiments on a DATE field:
SELECT * FROM tablename WHERE dateFieldName='2009-10-27'
SELECT * FROM tablename WHERE dateFieldName=#2009-10-27#
SELECT * FROM tablename WHERE dateFieldName=`2009-10-27`


or on a DATETIME field, same tests however replace = by >=

all this assumes a new record got added with dateFieldName set to NOW() or CURDATE() or whatever yields the current date or datetime.

And of course my entire test would sit in a try-catch with the catch displaying exception.ToString()

Smile | :)

Luc Pattyn

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages


GeneralRe: ODBC Type mismatch error Pin
TheJudeDude26-Oct-09 15:41
TheJudeDude26-Oct-09 15:41 
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 

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.