Hi,
I have a script that connects to a database which is in another country and
connected to our network thru a VPN.
The script tries to connect using ocilogon() and checks if a connection is
established. If not, it presents the visitor with a nice errorpage.
However, ocilogon takes a very
yeah...errora are important. I do not escape my quotation marks in a
query. I use single quotes within my insert and select statements.
If it says No valis MySQL resource then you are returning 0 records
which may be caused by escaping the quotations.
I follow this pattern
$sql =INSERT INTO
Not quite correct, No valis MySQL resource means the query and/or link
failed in connection in some way. A correct and proper query MAY easily
return 0 rows and that is correct and will give you a valid resource
(handle) and simply no data.
Bastien
From: J. Connolly [EMAIL PROTECTED]
CC:
Juffermans, Jos wrote:
Hi,
[snip]
Hello, again.
I'm afraid phrasing a question multiple ways over a course of days tends
not to have much success. In an effort to avoid populating google with
just the question, I will give to you what I would try.
( please note the irony of this now. )
Hi,
Martin Norland wrote:
MN I'm afraid phrasing a question multiple ways over a course of days tends
MN not to have much success. In an effort to avoid populating google with
MN just the question, I will give to you what I would try.
I understand your point but since I wasn't getting any
OK. I think I have resolved this issue. The problem I am
having now is that I have a simple table that is a list of systems to
exclude from the display. I am having trouble figuring out how to
structure my query to actually exclude the systems in this table. Here
is what I tried, and
Juffermans, Jos wrote:
I understand your point but since I wasn't getting any response and never
received a confirmation email from the system telling me that my email
account had been verified, I wasn't sure that the original post was actually
sent to the community. Oddly enough I got an email
Why does this NOT work?
UPDATE tipping SET score = 3 WHERE round1.game1 = H
AND tipping.username = jerry;
Please inform?
J
Find local movie times and trailers on Yahoo! Movies.
http://au.movies.yahoo.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
Why does this NOT work?
UPDATE tipping SET score = 3 WHERE round1.game1 = H
AND tipping.username = jerry;
For starters, you should quote strings in a query. There may also be a
problem with the round1 reference.
Larry
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
JeRRy wrote:
Why does this NOT work?
UPDATE tipping SET score = 3 WHERE round1.game1 = H
AND tipping.username = jerry;
Please inform?
You're not linking table round1 to table tipping in any way, and you've
got some quoting issues.
something like this:
UPDATE tipping SET score=3 WHERE
--- Larry E. Ullman [EMAIL PROTECTED]
wrote:
Why does this NOT work?
UPDATE tipping SET score = 3 WHERE round1.game1 =
H
AND tipping.username = jerry;
For starters, you should quote strings in a query.
There may also be a
problem with the round1 reference.
Larry
I was
missing single quotes around text
UPDATE tipping SET score = 3 WHERE round1.game1 =' H'
AND tipping.username = 'jerry';
bastien
From: JeRRy [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Why not ?
Date: Fri, 25 Mar 2005 04:05:28 +1100 (EST)
Why does this NOT work?
UPDATE tipping SET
On Thursday 24 March 2005 17:26, JeRRy wrote:
I was getting an error earlier stating round1 does not
exist, however it does. round1 table does not exist.
So does not say round1.game1 does not exist.
Does a table named round1 exist in your database?
If so and you are using mysql 4.0.4 you
The error message and when I have problems I find it's very helpful to
print the actual value of the $query variable.
In your case it looks like
AND acct_db.key1 LIKE \%\.AllMid_Data.CPU_Hostname
is adding AND acct_db.key1 LIKE %.AllMid_Data.CPU_Hostname
and you can't join two strings
Regardless of how I set the NLS_DATE_FORMAT parameter, when I do a select
statement DATE fields are returned in the Oracle default DD-MON-RR format.
I can successfully set NLS_DATE_FORMAT using either an environment variable
and restarting apache or by using ALTER SESSION SET NLS_DATE_FORMAT =
What the hell is wrong with this MYSQL query?? PHP keeps giving me the error
message:
You have an error in your SQL syntax. Check the manual that corresponds to your
MySQL server version for the right syntax to use near 'limit=2,
name='test1', email='[EMAIL PROTECTED]', password='t
thanks. Stupid me. I've been banging by head for the last two hours.
Bastien Koert [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
limit is a mysql keyword...change that field name and the corresonding
names
in your sql
bastien
From: HarryG [EMAIL PROTECTED]
To:
17 matches
Mail list logo
