RE: [PHP-DB] Re: Newbie? - help inserting into firebird1.0
| From: | jon-david schlough | Date: | Tue, 26 Mar 2002 19:35:51 +0000 |
| Subject: | RE: [PHP-DB] Re: Newbie? - help inserting into firebird1.0 | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-17928@lists.php.net to get a copy of this message | ||
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: lb@linux.local [mailto:lb@linux.local]On Behalf Of Lutz Bruckner
Sent: Tuesday, March 26, 2002 1:34 PM
To: php-db@lists.php.net
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
jdschlough@virtucomcsi.com (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