RE: pop-up box JOIN() to mysql not populating dates

2002-02-04 Thread Keith A. Calaman
Yeah..thanks a lot! -Original Message- From: Steve Howard [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 7:04 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: pop-up box JOIN() to mysql not populating dates One major benefit of placeholders is exactly what you said

RE: pop-up box JOIN() to mysql not populating dates

2002-02-04 Thread Steve Howard
for example in a connection: my $dbh - DBI->connect("DBI:ODBC:$ini{dsn}", $ini{userid}, $ini{pw}) || die Is that what you are looking for? Steve H. -----Original Message- From: Keith A. Calaman [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 5:25 PM To: Steve Howard

RE: pop-up box JOIN() to mysql not populating dates

2002-02-04 Thread Keith A. Calaman
everything! Thanks again. -Original Message- From: Steve Howard [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 03, 2002 12:41 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: pop-up box JOIN() to mysql not populating dates Correction to a syntax error I left. The insert query

RE: pop-up box JOIN() to mysql not populating dates

2002-02-02 Thread Steve Howard
commenting on your code :) Steve H. -Original Message- From: Steve Howard [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 02, 2002 11:00 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: pop-up box JOIN() to mysql not populating dates Keith, I can't tell much from wha

RE: pop-up box JOIN() to mysql not populating dates

2002-02-02 Thread Steve Howard
n a value that will cause problems with the query. If you get an error message, and want to go further, I'll be happy to see what we can do. Steve H. -Original Message- From: Keith A. Calaman [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 02, 2002 10:11 PM To: [EMAIL PROTECTED] Su

pop-up box JOIN() to mysql not populating dates

2002-02-02 Thread Keith A. Calaman
I am resending this to the group because I haven't gotten a response nor have I got it to work. I won't send it again but I thought someone who could help may have missed it. I have pasted my code below. The problem I am having is: my $ndate = join('-', $nyear,$nmonth,$nday); is printing back

pop-up box JOIN() to mysql not populating dates

2002-01-31 Thread Keith A. Calaman
I have pasted my code below. The problem I am having is: my $ndate = join('-', $nyear,$nmonth,$nday); is printing back to my form the exact format that should be correct to insert into mysql. However, when the INSERT runs the value does not get inserted properly. $nyear,$nmonth,$nday are grab