[PHP-DB] IIS5 - php4 ISAPI
hi, i have experienced the same problem with IIS, however upgrading (and it definitly IS an upgrade) to apache is not possible since i have production servers running IIS and no person to run apache that can do it in a production environment - my solution is to use CGI instead of ISAPI - it's not the schweeet low level access that ISAPI provides, but I don't think the ISAPI php lib is stable enough yet to use in critical apps - most have better running php as CGI. just my 2 sense of it. cheers, jon-david
[PHP-DB] Newbie? - help inserting into firebird1.0
hi.
i'm running: php4, firebird 1.0, and IIS all on win2k.
i'm just getting started 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,
);
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
--
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
