Hi,
Some of our scripts that generate customer-facing pages, need a connection
to a database. The problems is that the database is in Norway and -
allthough we have a VPN setup - the connection isn't always available.
In case the connection cannot be made, we can redirect the customer to a
nic
Hi,
Please send the code that you used with the hrefs so we can see where the
error occurs. Tell us what line the error occured (and what line in your
copied code that is).
Jos
-Original Message-
From: John Burroughs [mailto:[EMAIL PROTECTED]
Sent: 21 March 2005 03:29
To: php-db@lists.ph
Sorry to use this, but I don't know if my messages are arriving...
Can someone (only 1 please) reply that my message was received?
Jos
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi,
I'm trying to connect to an Oracle database (using ocilogon) which is in a
different country and connected to our serverfarm via a VPN (the database
has no public access). Unfortunately the VPN or the database is not always
available. In those cases I will present the visitor with a page expla
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 r
i Rene,
So far, I have found a few mistakes in your SQL:
$query .= " OR `variant` LIKE '%".$_GET['search']."%'";
Why do you have backtick-quotes around variant? Know that backticks are used
to call system commands. You also use these backticks in the ORDER BY lines.
My guess is the backti
Hi,
You could do something like this:
SELECT 'Accounts' as department, Accounts as id FROM mytable WHERE Accounts
IS NOT NULL
UNION ALL
SELECT 'Human Resources' as department, HR as id FROM mytable WHERE HR IS
NOT NULL
UNION ALL
SELECT 'Support' as department, Support as id FROM my
Hi,
If I understand correctly, you're using
"include/function_gd.php?route_photo=$thumb" as image source which is the
script you pasted. If you use a script as image source, the script should
output the image data - not just store the image.
I'm not sure what you're trying to do but if you have a
line
ImageDestroy($thumb);
...
in the other script instead of
echo ("");
do this:
require("include/function_gd.php?route_photo=$thumb");
Jos
-Original Message-
From: Craig Hoffman [mailto:[EMAIL PROTECTED]
Sent: 06 April 2005 18:12
To: php-db@lists.
Hi,
I'm afraid I can't help you with the query - I'm used to Oracle which as a
bigger set of SQL commands.
I can help you with your PHP question. If you want to put a variable in a
query, you can add the variable directly into the string:
$sql_query = "select zg_longitude from zip_code wh
If you do "SELECT LEFT(loc1,3) FROM openart_table" the column name in $row
is probably not "loc1". Try this: "SELECT LEFT(loc1,3) AS loc1 FROM
openart_table". Also, after the fetch you can do some debuggin thru this:
"; print_r($row); print "";
?>
That prints out a list of al
Hi,
Imagine this code:
Both queries should result in the same data but as soon as I use the binding
no rows are returned. I can't see what I'm doing wrong here. Can someone
help me?
Jos
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
riginal Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 20 April 2005 13:40
To: [EMAIL PROTECTED]; php-db@lists.php.net
Subject: RE: [PHP-DB] OCI Binding problem
Sorry, trigger happy. Also try ":postalcode" in uppercase.
Neil
-Original Message-----
From: Juffe
Juffermans, Jos would like to recall the message, "[PHP-DB] OCI Binding
problem".
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Update:
I've found a workaround:
Somehow Oracle will interpret the :postalcode as a numeric value in this
case, eventhough the column is a varchar. By adding '' || Oracle converts it
to a string.
Jos
-Original Message-
From: Juffermans, Jos [mailto:[EMAIL PROTECTED]
Hi,
I have a script that needs to connect to two database. Unfortunately, one of
them uses US7ASCII encoding (similar to LATIN1) and the other one uses UTF-8
encoding.
Before I connect to the first one, I set these environment variables:
putenv("NLS_LANG=AMERICAN_AMERICA.US7ASCII");
Hi,
I'd just like to point out that one important option was overlooked: You
could create a SQL query which would read the folders AND the mimetype/icon
info at the same time. This means that you can have your database do most of
the work for you which normally means it's faster.
Rgds,
Jos
-
As far as I know there is no limit on the amount of variables, however there
is a limit on the length of the URL including query (I believe 256
characters).
Normally I would use hidden fields in a form (method POST) for this kinda
stuff.
Jos
-Original Message-
From: [EMAIL PROTECTED] [m
mysql_fetch_array will always only return 1 row. $array['town'] won't be an
array but just a text and is therefor interpreted differently.
If you can give us more information (ie data model, output sample) we might
be able to help you a bit better.
Jos
-Original Message-
From: J. Connoll
Hi,
Since you're telling mysql "Avg(RawData) as Mn" the index in $myrow won't be
"Avg(RawData)", it'll just be "Mn".
Try printing the entire $myrow to find out what you're receiving from mysql:
print ""; print_r($myrow); print "";
That will show you the keys that you should use.
Jos
--
ho "Phone: " . $this_row{"phone"} . "";
}
echo "";
echo "";
Jos
PS: Please always reply to [EMAIL PROTECTED]
-Original Message-
From: J. Connolly [mailto:[EMAIL PROTECTED]
Sent: 02 May 2005 16:14
To: Juffermans, J
Hi,
If you expect your variables to be generated automatically, you may find
that newer versions of PHP have that disabled by default - because it's less
secure.
Try to read $_POST{"formfieldname"} to get your data...
To quickly find out all the post data that you received:
"; print_r($_POST); p
Can you also send us the output generated by PHP? Ie the output HTML...
Jos
-Original Message-
From: Ng Hwee Hwee [mailto:[EMAIL PROTECTED]
Sent: 09 May 2005 10:48
To: PHP DB List
Subject: [PHP-DB] R6025 Error
Hi all,
I'm having a problem with a R6025 error. What happened is that I hav
Personally, I always check variables that I'm using in a query. If I'm
expecting eg a session id (32 hex characters) I check that the session id is
a valid one - ie "!$[0-9a-f]{32}$!" (I use ! as delimiter in regexps).
Allthough mysql_escape_string will probably protects me from injections, I
stil
Can you send the query and some code that you're using? You probably want to
loop like this:
while ($row = mysql_fetch_assoc($cursor)) {
echo $row{"case_note"} . "";
}
Jos
-Original Message-
From: John R. Sims, Jr. [mailto:[EMAIL PROTECTED]
Sent: 17 May 2005 03:07
To: php-db@list
Hi,
Instead of doing a SELECT *, specify the fields that you require. Allthough
you may think the rows are exactly the same, one might be empty ("") and one
null which is not the same.
You are more likely to get the result that you need if you specify the
fields:
SELECT DISTINCT somedata, rev, a
What are you trying to connect to? Do you have a webservice on the second
domain? Is it a database - and if so, which?
-Original Message-
From: JeRRy [mailto:[EMAIL PROTECTED]
Sent: 17 May 2005 08:33
To: php-db@lists.php.net
Subject: [PHP-DB] Connection Question!
Hi,
Okay lets say I ow
In the second loop you do an array_shift($entry) which should be
array_shift($all).
Perhaps a foreach loop would be easier:
Jos
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
Sent: 18 May 2005 22:47
To: php-db@lists.php.net
Subject: [PHP-DB] Help!!!
Hi,
I didn't even think PHP would do anything until I just tried it.
";
}
?>
outputs:
A
B
C
X
Y
Z
AA
AB
AY
AX
YA
YB
YY
YZ
Why it continues after Z is not clear to me, and why it doesn't continue
until ZZ isn't either.
This works better and (more importantly) as expected:
"
29 matches
Mail list logo