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/)
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,
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
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
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
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
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/
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
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
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
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
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
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
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
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
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
$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,
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
[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
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:
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
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).
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:
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,
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
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
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
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
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
29 matches
Mail list logo