[PHP-DB] Re: Newbie? - help inserting into firebird1.0
Hi Jon-David, not sure that this is the only problem, but rewrite your query like this (single quotes araound the values): $query=insert into BUGS (APP, APP_VERSION, BUILD, OS, SEVERITY, BUG_PRIORITY, BUG_STATE, SB_USER, STEPS, EXPECTED, OBSERVED, STATUS, OPENED) values ('$txtApp','$numVersion','$txtBuild','$txtOs', '$frmSeverity', '$numPriority', '$txtState', '$txtUser', '$txtSteps', '$txtExpected', '$txtObserved', '$frmStatus', 'NOW');; Lutz [EMAIL PROTECTED] (Jon-David Schlough) writes: $query=insert into BUGS (APP, APP_VERSION, BUILD, OS, SEVERITY, BUG_PRIORITY, BUG_STATE,SB_USER, STEPS, EXPECTED, OBSERVED, STATUS, OPENED) values ($txtApp,$numVersion,$txtBuild,$txtOs, $frmSeverity, $numPriority, $txtState, $txtUser, $txtSteps, $txtExpected, $txtObserved, $frmStatus, NOW);; -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: Newbie? - help inserting into firebird1.0
you're right Lutz, that is not my only problem- turns out this statement is wrought with errors :| i should not have been referring to those values as variables...stupid lamer mistake, just the name works...also, changed the double quotes to single quotes, per Lutz's suggestion, and that worked as well...so i'm getting closer. now it tosses: Warning: InterBase: conversion error from string numVersion in C:\Inetpub\dev_root\slugbug\issue_send4.php on line 19 Error. Can't insert the record with the query: insert into BUGS (APP, APP_VERSION, BUILD, OS, SEVERITY, BUG_PRIORITY, BUG_STATE, SB_USER, STEPS, EXPECTED, OBSERVED, STATUS, OPENED) values ( 'txtApp','numVersion','txtBuild','txtOs', 'frmSeverity', 'numPriority', 'txtState', 'txtUser', 'txtSteps', 'txtExpected', 'txtObserved', 'frmStatus', 'NOW')! so this is the string conversion problem i knew was there, but hadn't gotten far enough to discover. currently RingTFM... as per usual, all help is greatly appreciated. cheers, jon-david -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Lutz Bruckner Sent: Tuesday, March 26, 2002 1:34 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: Newbie? - help inserting into firebird1.0 Hi Jon-David, not sure that this is the only problem, but rewrite your query like this (single quotes araound the values): $query=insert into BUGS (APP, APP_VERSION, BUILD, OS, SEVERITY, BUG_PRIORITY, BUG_STATE, SB_USER, STEPS, EXPECTED, OBSERVED, STATUS, OPENED) values ('$txtApp','$numVersion','$txtBuild','$txtOs', '$frmSeverity', '$numPriority', '$txtState', '$txtUser', '$txtSteps', '$txtExpected', '$txtObserved', '$frmStatus', 'NOW');; Lutz [EMAIL PROTECTED] (Jon-David Schlough) writes: $query=insert into BUGS (APP, APP_VERSION, BUILD, OS, SEVERITY, BUG_PRIORITY, BUG_STATE,SB_USER, STEPS, EXPECTED, OBSERVED, STATUS, OPENED) values ($txtApp,$numVersion,$txtBuild,$txtOs, $frmSeverity, $numPriority, $txtState, $txtUser, $txtSteps, $txtExpected, $txtObserved, $frmStatus, NOW);; -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Newbie? - help inserting into firebird1.0
if APP_VERSION is defined as decimal you can not insert a string. So leaving away the quotes around $numVersion should bring you closer. Lutz [EMAIL PROTECTED] (Jon-David Schlough) writes: you're right Lutz, that is not my only problem- turns out this statement is wrought with errors :| i should not have been referring to those values as variables...stupid lamer mistake, just the name works...also, changed the double quotes to single quotes, per Lutz's suggestion, and that worked as well...so i'm getting closer. now it tosses: Warning: InterBase: conversion error from string numVersion in C:\Inetpub\dev_root\slugbug\issue_send4.php on line 19 Error. Can't insert the record with the query: insert into BUGS (APP, APP_VERSION, BUILD, OS, SEVERITY, BUG_PRIORITY, BUG_STATE, SB_USER, STEPS, EXPECTED, OBSERVED, STATUS, OPENED) values ( 'txtApp','numVersion','txtBuild','txtOs', 'frmSeverity', 'numPriority', 'txtState', 'txtUser', 'txtSteps', 'txtExpected', 'txtObserved', 'frmStatus', 'NOW')! so this is the string conversion problem i knew was there, but hadn't gotten far enough to discover. currently RingTFM... as per usual, all help is greatly appreciated. cheers, jon-david -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php