RE: [PHP-DB] Converting "text" fields to "integer" in queries with ODBC connection to an MS Access file

2001-11-15 Thread Christian Sandfeld
doh! ofcourse... that actually works. Thanks a bunch :) /Christian -Original Message- From: Gonzalez, Lorenzo [mailto:[EMAIL PROTECTED]] Sent: 15. november 2001 16:11 To: Christian Sandfeld; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Converting "text" fields to "integer&q

RE: [PHP-DB] Converting "text" fields to "integer" in queries with ODBC connection to an MS Access file

2001-11-15 Thread Christian Sandfeld
01 14:57 To: Christian Sandfeld; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Converting "text" fields to "integer" in queries with ODBC connection to an MS Access file Some of the databases I work with would support this as 'between' on two text fields that are sortable a

[PHP-DB] Converting "text" fields to "integer" in queries with ODBC connection to an MS Access file

2001-11-15 Thread Christian Sandfeld
Hi list, I wonder if anyone can help me out here. I'm pulling some data from an MS Access file using the ODBC driver provided with Windows NT 4.0 server (Option pack, and SP6a applied), and want to limit the result set with a where clause like this one: ... WHERE (PARTNUMBER > 37010)

RE: [PHP-DB] Adobc error

2001-06-28 Thread Christian Sandfeld
It means that the registro.php script can't find the required file adodb.inc.php. Check the path of the requite statement on line 7 of registro.php (looking at the error msg. it could be the '.:' before the '/usr...' causing the problem). /Christian -Original Message- From: Wilmar PĂ©rez

RE: [PHP-DB] MySQL Error???

2001-06-28 Thread Christian Sandfeld
Brian, Sounds to me as if the field you have as primary key is set to type 'TINYINT'. TINYINT's 'signed' range accepts values from -128 to 127, when set to 'unsigned' it accepts values from 0 to 255. In your place I would concider changing that column to a 'SMALLINT' and set it to 'unsigned'. Th

[PHP-DB] making queries

2001-06-27 Thread Christian Sandfeld
Yes, it's possible. What you do is write the var names and values after the page name as follows: click my link This would call a script called mylink.php, initializing two vars, namely $foo (containing the value 'bar') and $bar (containing the value 'foo'). So, to pass info to a script using a