Maybe the semicolon at the end of the statement must be removed.

Fred

jdschlough wrote:

> hi.
>
>
> i'm running: php4, firebird 1.0, and IIS all on win2k.
>
> i'm still only scratched the surface with php and firebird, so please
> forgive me if the error is obvious. i hunted around for examples, the
> best
> of which i've found btw is at
> http://www.ibphoenix.com/ibp_howto1.html -
> thought i did this right, i have no trouble selecting from the
> database but
> inserting is giving me some grief...
>
> my table:
>
> RECREATE TABLE BUGS
> (
> BUG_ID INTEGER NOT NULL,
> APP VARCHAR( 25) CHARACTER SET NONE COLLATE NONE,
> APP_VERSION DECIMAL( 3, 2),
> BUILD VARCHAR( 5) CHARACTER SET NONE COLLATE NONE,
> OS VARCHAR( 25) CHARACTER SET NONE COLLATE NONE,
> SEVERITY VARCHAR( 25) CHARACTER SET NONE COLLATE NONE,
> BUG_PRIORITY VARCHAR( 5) CHARACTER SET NONE COLLATE NONE,
> BUG_STATE VARCHAR( 10) CHARACTER SET NONE COLLATE NONE,
> SB_USER VARCHAR( 25) CHARACTER SET NONE COLLATE NONE,
> STEPS VARCHAR( 500) CHARACTER SET NONE COLLATE NONE,
> EXPECTED VARCHAR( 500) CHARACTER SET NONE COLLATE NONE,
> OBSERVED VARCHAR( 500) CHARACTER SET NONE COLLATE NONE,
> OPENED DATE,
> CLOSED DATE,
> HYPOTHESIS VARCHAR( 500) CHARACTER SET NONE COLLATE NONE,
> SOLUTION VARCHAR( 500) CHARACTER SET NONE COLLATE NONE,
> STATUS VARCHAR( 15) CHARACTER SET NONE COLLATE NONE
> )
>
>
>
> and then the add_issue.php
>
> <?
> $conn=ibase_connect
> ("ipaddress:c:\\Firebird\\data\\slugBug.gdb", "SYSDBA","XXXX");
> if (!$conn) {
> echo "Acess Denied!<br>";
> exit;
> }
> $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");";
> $result=ibase_query($conn,$query);
> if (!$result) {
> echo "Error. Can't insert the record with the query: $query! $back";
> exit;
> }
> echo "Record saved. $back";
> ibase_close($conn);
> ?>
>
>
> finally, the error message:
>
> Warning: InterBase: Dynamic SQL Error SQL error code = -104 Token
> unknown - line 3, char 47 , in
> C:\Inetpub\dev_root\slugbug\issue_send2.php on line 18
> 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
> (games/software,1.0,rc1,win2000,
> , 5, , jds, [PHP-DB][PHP-DB][PHP-DB][PHP-DB],
> [PHP-DB][PHP-DB][PHP-DB][PHP-DB],
> [PHP-DB][PHP-DB][PHP-DB][PHP-DB][PHP-DB][PHP-DB][PHP-DB]', , NOW);!
>
> do i need to do some string conversion here? or the INSERT statement
> wrong?
>
> a combination of the two? i'm currently RingTFM, but any help would be
> greatly appreciated.
>
> TIA!
>
> jon-david
>
>
>
>
> *Yahoo! Groups Sponsor*
> ADVERTISEMENT
> <http://rd.yahoo.com/M=213858.1879370.3379539.1261774/D=egroupweb/S=1705115386:HM/A=763352/R=0/*http://www.classmates.com/index.tf?s=5085>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/>.

[Non-text portions of this message have been removed]