[PHP-DB] Not associated with a trusted SQL Server connection

2002-07-15 Thread Gabor Niederlaender
Hi! I am working on a MSSQL DB. As I left last week on friday, everything worked fine, but today I got the error message above... What can be the problem. I think it is something with privileges and user rights, isn't it? Please help, Gabor -- PHP Database Mailing List (http://www.php.net/)

[PHP-DB] Re: Not associated with a trusted SQL Server connection

2002-07-15 Thread Gabor Niederlaender
I realized that the Authentification in the Properties of the SQL-Server has to be changed to sql-server AND(!) Windows. Is there a way to get it working if I set that to only Windows? Greetings, Gabor --- Hi! I am working on a MSSQL DB. As I left last week on friday,

[PHP-DB] Re: extract data from database into an array

2002-07-15 Thread Marcel Schindler
Chip Wiegand [EMAIL PROTECTED] wrote I have a database, all the data is numbers. I want to make a query that will extract the data and then make it available in an array, so the array is populated 'real-time'. I could just enter the number into an array manually, but I want to automate the

[PHP-DB] PHP database

2002-07-15 Thread Tomator
Hello I'm to have database, but server's administrator refuses to install MySQL nor PHP MySQL support :( He told me he won't install it and I should use textfiles if I want to have database. I don't want to write engine to textfiles, so... Can You point where can I find PHP code which realize

[PHP-DB] Header problem

2002-07-15 Thread Dave Carrera
Hi All My isp decided to upgrade to 4.2.1 without letting us know? So recoded scripts with new $_VARS in place but one thing refuses to work I have in my script a call to header location. header( Location: ./file.php); Works on my system but not on theirs I have 4.21 also. Is there

Re: [PHP-DB] PHP database

2002-07-15 Thread Steve Farmer
Hi, I would try to convince the admin that a DB like MYSql (which is actually part of the standard install under Redhat now) is much more secure than storing data in text files !! HTH Steve At 11:02 AM +0200 15/7/02, Tomator wrote: Hello I'm to have database, but server's administrator

[PHP-DB] copy a table

2002-07-15 Thread Matt Babineau
What was the SQL that could be run to copy a table, I want to make a duplicate of a table, it just having a different name? Matt Babineau MCWD / CCFD - e: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] p: 603.943.4237 w: http://www.criticalcode.com/

[PHP-DB] MSSQL and NT

2002-07-15 Thread Gabor Niederlaender
Hi all! I went after my problem with the NT authentification and I found out, that if you want to make a NT-based Authentification (f.ex for an ODBC-Connection) the I_USR will be seen as the actual user... I granted then rights to the I_USR in the DB, but this way, I cannot distinguish which

Re: [PHP-DB] copy a table

2002-07-15 Thread Michael Bretterklieber
HI, insert into blabla select * from hohohoho bye, Matt Babineau schrieb: What was the SQL that could be run to copy a table, I want to make a duplicate of a table, it just having a different name? Matt Babineau MCWD / CCFD - e: mailto:[EMAIL

Re: [PHP-DB] Header problem

2002-07-15 Thread Paul Burney
on 7/15/02 5:09 AM, Dave Carrera at [EMAIL PROTECTED] appended the following bits to my mbox: I have in my script a call to header location. header( Location: ./file.php); Works on my system but not on theirs Not really database related so it should be on php-general. FWIW, I believe

[PHP-DB] load data

2002-07-15 Thread Natividad Castro
Hi to all, I changed Linux from version 7.2 to 7.3 and now when I try to load data using LOAD DATA LOCAL INFILE I got the following error: The used command is not allowed with this MySQL version. I enable --local-infile=1 But I'm still getting the same error. Any help, is greatly appreciate it

RE: [PHP-DB] Select a subset?

2002-07-15 Thread Gary . Every
I think the paging function is what you want SELECT * from table limit 0,10 for the first ten records SELECT * from table limit 11,20 for the next ten, etc. Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com

Re: [PHP-DB] load data

2002-07-15 Thread Jason Wong
On Monday 15 July 2002 22:03, Natividad Castro wrote: Hi to all, I changed Linux from version 7.2 to 7.3 and now when I try to load data using LOAD DATA LOCAL INFILE I got the following error: The used command is not allowed with this MySQL version. I enable --local-infile=1 But I'm still

Re: [PHP-DB] copy a table

2002-07-15 Thread Jason Wong
On Monday 15 July 2002 21:16, Michael Bretterklieber wrote: HI, insert into blabla select * from hohohoho bye, Matt Babineau schrieb: What was the SQL that could be run to copy a table, I want to make a duplicate of a table, it just having a different name? In other words this has

Re: [PHP-DB] Select a subset?

2002-07-15 Thread Clive Bruton
Adam Alkins wrote at 15/07/02 04:06 mysql_num_rows just counts the amount of rows in a query, so if you only selected 10 rows, it will return 10. If you want to count all the rows in the table, its best to use the COUNT() function SELECT COUNT(*) FROM table In my example, I've selected all

Re: [PHP-DB] extract data from database into an array

2002-07-15 Thread chip . wiegand
Adam Alkins [EMAIL PROTECTED] wrote on 07/13/2002 07:56:46 PM: I have a database, all the data is numbers. I want to make a query that will extract the data and then make it available in an array, so the array is populated 'real-time'. I could just enter the number into an array

Re: [PHP-DB] extract data from database into an array

2002-07-15 Thread Adam Voigt
$query = mysql_query(SELECT whatever FROM whatever;); while($row = mysql_fetch_array($query)) $construct[] = $row[whatever]; That will give you an array (construct) with position 0 being the first row, position 1 being the second row, and so on. Adam Voigt [EMAIL PROTECTED] On Mon,

[PHP-DB] MS Access - default value in create table

2002-07-15 Thread Nuttzy
I can create tables and perform alterations just fine. However, if I try to specify a DEFAULT value in either CREATE TABLE or ALTER TABLE, it craps out on me. For example, this works ALTER TABLE phpbb_mytable ALTER COLUMN LastName TEXT(40) ...but this doesn't ALTER TABLE

[PHP-DB] RE: PHP meetup [CROSS-POST] Meet other PHP Developers in Your Area

2002-07-15 Thread Jay Blanchard
[snip] No, it's not a dating service :) Want to meet other PHP developers in your area? Check out: http://php.meetup.com/ Pretty nifty idea... especially given the lack of user groups in the U.S. I thought for others who had not seen this I would post this. There is probably already a user

[PHP-DB] RE: PHP meetup [CROSS-POST] Meet other PHP Developersin Your Area

2002-07-15 Thread Martin Clifford
Yes, everyone please join up! I would love to find more developers in the Maryland area, and I'm sure others would in their areas as well! Let's do the great american get togeth... err... the great php get together! Martin Clifford Homepage: http://www.completesource.net Developer's Forums:

[PHP-DB] header function

2002-07-15 Thread Mohammad Forouhar-Fard
Hi, I have a problem with function header(Location:xy.php?var=2). I have not any text (print echo or display any text) at all before I set a cookie If I try to execute this function of Apache server in my Company it is all auf OK. But if I try to run at home I have even the same error

Re: [PHP-DB] header function

2002-07-15 Thread Steve Cayford
What's on line 3 of Auth_user.php ? If you have anything outside of the ?php ... ? tags it will start the html output. Even just an empty line. -steve On Monday, July 15, 2002, at 04:09 PM, Mohammad Forouhar-Fard wrote: Hi, I have a problem with function header(Location:xy.php?var=2).

AW: [PHP-DB] header function

2002-07-15 Thread Mohammad Forouhar-Fard
Nothing it is only header function. No I don't have anything outside. In this case I am connected to the DB. if($v_action ==delete){ $DBquery($cfgDB[data],UPDATE $cfgTbl[accounts] SET acc_service='' WHERE acc_id='$v_id') or die(cannot UPDATE$cfgTbl[accounts]:br.mysql_error()); header(Location:

[PHP-DB] Updating a CLOB-- OCI_INVALID_HANDLE

2002-07-15 Thread Anthony Carlos
Hello, Has anyone come across difficulty updating a CLOB in Oracle? I have been able to follow the documentation to insert a new clob by first inserting an EMPTY_CLOB() into the row, and then calling the save method of the OCINewDescriptor/CLOB locator: $conn = OCILogon(username, password,

Re: [PHP-DB] PHP database

2002-07-15 Thread Rick Widmer
Hello I'm to have database, but server's administrator refuses to install MySQL nor PHP MySQL support :( He told me he won't install it and I should use textfiles if I want to have database. Sounds like time too find another hosting provider. Rick -- PHP Database Mailing List

[PHP-DB] PHP4/mssql_query INSERT problems

2002-07-15 Thread Salve Tinkerworth
Why do I keep getting messages like: INSERT INTO OPS (CampaignID,[Description],PhoneInventory,URLInventory) VALUES (463,'In and Out','','') Warning: MS SQL message: Line 1: Incorrect syntax near '463'. (severity 15) in c:\inetpub\wwwroot\intranet2\ccp\campaign_edit.html on line 62 Warning: MS

Re: [PHP-DB] PHP4/mssql_query INSERT problems

2002-07-15 Thread John Coder
On Mon, 2002-07-15 at 21:01, Salve Tinkerworth wrote: Why do I keep getting messages like: INSERT INTO OPS (CampaignID,[Description],PhoneInventory,URLInventory) VALUES (463,'In and Out','','') Warning: MS SQL message: Line 1: Incorrect syntax near '463'. (severity 15) in

Re: [PHP-DB] PHP4/mssql_query INSERT problems

2002-07-15 Thread Salve Tinkerworth
Thanks, I tried that. It results in: INSERT INTO OPS (CampaignID,[Description],PhoneInventory,URLInventory) VALUES ('467','Employee Incentive','','') Warning: MS SQL message: Unclosed quotation mark before the character string '467'. (severity 15) in

[PHP-DB] Re: PHP4/mssql_query INSERT problems

2002-07-15 Thread Salve Tinkerworth
I updated the mdac drivers on the Win2000 that was running PHP4 on IIS and it seemed to resolve the problem. If anyone has good code for detecting errors after issuing mssql_query please post them. Thanks! Salve Salve Tinkerworth [EMAIL PROTECTED] wrote in message [EMAIL