That makes complete sense.
Thank you Joshua.
Best,
Karl DeSaulniers
Design Drumm
http://designdrumm.com
> On Mar 5, 2017, at 6:44 PM, Arneson, Joshua wrote:
>
> If you have multiple calls to the database that are grouped, definitely
> perform them during the same connection session. The b
If you have multiple calls to the database that are grouped, definitely perform
them during the same connection session. The bottom line is unless the overhead
associated with opening and closing the connection is going to be an issue
programmatically, keep connections brief and group your trans
Ah, thanks for the reply Joshua.
Duly noted. So when is it bad to make multiple open and close connections then?
I am guessing that could have some impact with lots of users too. Yes?
If the website in question does not have a lot of users (less than 1,000), is
this still a bad call to keep an o
Right off the bat, you need to consider concurrency issues. Depending on the
size of your user base and level of activity this could become a major issue.
In the end, why hold an open connection for 15 minutes just to process 20-30
transactions that take 20-30ms each? Just better (under most cir
Thanks Bert,
Sorry for late response, but I had to step away from this for a moment to work
on other things.
Will most likely be back though as things are not working still.
Thank you for your responses.
Best,
Karl DeSaulniers
Design Drumm
http://designdrumm.com
> On Sep 13, 2016, at 2:15 A
On 13/09/16 08:42, Karl DeSaulniers wrote:
On Sep 12, 2016, at 2:53 PM, B. Aerts wrote:
On 12/09/16 05:24, Karl DeSaulniers wrote:
Hello All,
Hoping you can help clear my head on this. I have two MySQL tables for custom
fields data to be stored.
custom_fields custom
> On Sep 12, 2016, at 2:53 PM, B. Aerts wrote:
>
> On 12/09/16 05:24, Karl DeSaulniers wrote:
>> Hello All,
>> Hoping you can help clear my head on this. I have two MySQL tables for
>> custom fields data to be stored.
>>
>> custom_fields custom_fields_meta
>>
>> custom_f
tware Engineer, Advanced Cloud Solutions, GTS
> >
> > IBM Senior Certified IT Specialist - L3 Thought Leader
> > The Open Group Certified IT Specialist - L3 Distinguished
> > Cloud, Java, PHP, BlackBerry, DB2 & Solaris Certified
> >
> >
> >
> &g
, DB2 & Solaris Certified
>
>
>
>
>
>
> Ethan Rosenberg wrote on 08/21/2013
> 11:59:19 PM:
>
> > From: Ethan Rosenberg
> > To: Daniel Krook/White Plains/IBM@IBMUS
> > Cc: PHP Database List
> > Date: 08/21/2013 11:59 PM
> > Subject: Re: [PHP-
> Date: 08/21/2013 11:59 PM
> Subject: Re: [PHP-DB] mysql query
>
> On 08/21/2013 11:30 PM, Daniel Krook wrote:
> Ethan,
>
> It's hard to tell from the code formatting in your email what the
> exact problem might be, but a few reasons that this might fail in
&
Ethan,
It's hard to tell from the code formatting in your email what the exact
problem might be, but a few reasons that this might fail in PHP rather
than when sent to MySQL with hardcoded values:
1. var_dump/print_r $_POST to see what you're getting as input is what
you expect (and sanitize!
On 08/21/2013 07:52 PM, Toby Hart Dyke wrote:
1) What is the error message?
2) This has an error:
>values ('$upc', $qnt,'$mnf','$itm', odrpt, 0, $stk)
Missing '$' in front of 'odrpt'.
Toby
On 8/22/2013 12:48 AM, Ethan Rosenberg wrote:
Dear List -
I can't figure this out
mysql> des
1) What is the error message?
2) This has an error:
>values ('$upc', $qnt,'$mnf','$itm', odrpt, 0, $stk)
Missing '$' in front of 'odrpt'.
Toby
On 8/22/2013 12:48 AM, Ethan Rosenberg wrote:
Dear List -
I can't figure this out
mysql> describe Inventory;
+-+-+-
Alexander Pletnev wrote:
> Hi everyone, im new here, so please correct me if i created or formated
> topic incorrectly.
>
> I found a problem. I have a simple query for my needs:
>
> $stmt = $dbh->prepare("SELECT concat(first_name,' ',last_name) as
> full_name,t.* FROM `specialists` `t`
$stmt = $dbh->prepare("SELECT concat(first_name,' ',last_name) as
full_name,t.* FROM `specialists` `t` HAVING full_name like '%:query%'");
How about '%:$query%' instead of '%:query%' ? Does that solve the problem?
Thanks,
On Thu, Jun 27, 2013 at 5:21 PM, Alexander Pletnev <
pletnev.rusa...@gma
You probably miss the mysql extension or have different one than you are
calling.
Please call
in script to see what extensions are loaded. if there is some other module
supporting mysql just use different way to run sql.
otherwise you need to look into php.ini and see if module is available and
so sorry
function getOptGrps($ID=null){
$extraClause = "";
if($ID != "All")
{
$extraClause = " WHERE OptGrpID LIKE '$ID' ";
}
$q = "SELECT * FROM ".OPT_GRPS_TABLE.$extraClause;
$result = $this->query($q);
/* Error occurred, return given name by defau
On May 7, 2010, at 4:16 AM, Onur Yerlikaya wrote:
function getOptGrps($ID=null){
if ($ID == "All") {
$ID = "%"; // % = MySQL multi character wildcard
}
$extraClause = "";
if(!is_null($ID))
{
$extraClause = " WHERE OptGrpID LIKE '$ID' ";
}
$q =
function getOptGrps($ID=null){
if ($ID == "All") {
$ID = "%"; // % = MySQL multi character wildcard
}
$extraClause = "";
if(!is_null($ID))
{
$extraClause = " WHERE OptGrpID LIKE '$ID' ";
}
$q = "SELECT * FROM ".OPT_GRPS_TABLE.$extraClause;
$r
try this
SELECT DATE_ADD('2008-01-02', INTERVAL -7 DAY);
Chaitanya
On Tue, Apr 13, 2010 at 12:01 PM, Ron Piggott <
ron.pigg...@actsministries.org> wrote:
> It is in a 'date' column type -MM-DD
>
> > what is the format of the date u are storing ?
> >
> > Chaitanya
> >
> >
> >
> > On Tue,
It is in a 'date' column type -MM-DD
> what is the format of the date u are storing ?
>
> Chaitanya
>
>
>
> On Tue, Apr 13, 2010 at 11:50 AM, Ron Piggott <
> ron.pigg...@actsministries.org> wrote:
>
>> I am trying to write a mySQL query on my "stats" table. I am trying to
>> determine the num
Ron Piggott wrote:
I am trying to write a mySQL query on my "stats" table. I am trying to
determine the number of records (users) during a 7 day period ending
yesterday. I always to keep it current ... Yesterday will keep changing.
In other words I want to know the number of users who accessed
what is the format of the date u are storing ?
Chaitanya
On Tue, Apr 13, 2010 at 11:50 AM, Ron Piggott <
ron.pigg...@actsministries.org> wrote:
> I am trying to write a mySQL query on my "stats" table. I am trying to
> determine the number of records (users) during a 7 day period ending
> yes
ginal Message-
From: Chris [mailto:dmag...@gmail.com]
Sent: Sunday, April 11, 2010 6:26 PM
To: David Murphy
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] Mysql completing Query fast but mysql->query() takes
long time to return even single selects/updates
David Murphy wrote:
> As you c
just a pointer.. have you enabled php profiling to see if it actually
mysql->query() that takes 20 secs ?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
David Murphy wrote:
As you can see PHP claims it took 20 seconds for mysql->query() to return
but mysql think is took around 1.0s
This is from our application
I enabled profile in mysql to determine why an update took 20seconds. As
you can see MySQL reported no where near that amount o
e-
From: Chaitanya Yanamadala mailto:dr.virus.in...@gmail.com>>
Date: Fri, 09 Apr 2010 19:26:22
Cc: mailto:php-db@lists.php.net>>
Subject: Re: [PHP-DB] mysql/php time out issue
have u checked max_execution_time
Chaitanya
On Fri, Apr 9, 2010 at 7:17 PM,
-Original Message-
From: Chaitanya Yanamadala mailto:dr.virus.in...@gmail.com>>
Date: Fri, 09 Apr 2010 19:26:22
To: Stephen Sunderlinmailto:stephen.sunder...@verizon.net>>
Cc: mailto:php-db@lists.php.net>>
Subject: Re: [PHP-DB] mysql/php time out issu
-3753
>
> -Original Message-
> From: Chaitanya Yanamadala
> Date: Fri, 09 Apr 2010 19:26:22
> To: Stephen Sunderlin
> Cc:
> Subject: Re: [PHP-DB] mysql/php time out issue
>
> have u checked max_execution_time
>
>
> Chaitanya
>
>
>
> On Fri, Ap
have u checked max_execution_time
Chaitanya
On Fri, Apr 9, 2010 at 7:17 PM, Stephen Sunderlin <
stephen.sunder...@verizon.net> wrote:
> I'm running php 5.1.6 with mysql 5.0.45 on CentOS 5.3 box trying to loop
> through a while statement to send about 3000 email using phpmailer. It's
> work
On 8 April 2010 00:13, 3dgtech wrote:
> Quick question. I have an AJAX component that fires a "like" query for each
> "key up" event (since it's a like % query there is no indexing or caching
> possible). While everything works fine, I was contemplaining downloading the
> ~1500 rows into a session
Chris I spent 3 hours debugging this query myself. I got as far as
putting '' around 2009-12-25 to get the desired results. I just added the
word DATE. It works, thanks.
Chris I run a verse of the day e-mail list. This query determines the
logic of the content (year round, Easter and Christma
ron.pigg...@actsministries.org wrote:
The query from my previous post was only part of a larger query. This is
the entire query:
SELECT GREATEST( IF( CURDATE( ) >= DATE_SUB( DATE( FROM_UNIXTIME(
1239508800 ) ) , INTERVAL LEAST( 14, (
SELECT COUNT( * )
FROM `verse_of_the_day_Bible_verses`
WHERE
I found the problem. The first subquery needed "AS" aliases. I am
learning more of what mySQL is capable of and appreciate the help. Ron
-Original Message-
From: TG
To: ron.pigg...@actsministries.org
Subject: Re: [PHP-DB] mySQL query syntax error
Date: Sat, 14 Nov 2009 07:1
Drew Stokes wrote:
Hello all,
I have an enterprise application that needs to be
optimized/re-engineered. In the process of re-designing the framework,
i stumbled across the idea of storing large mysql result sets in
multi-dimensional arrays for easy/quick reference.
Basically, my applicatio
Bastien Koert napsal(a):
2009/6/3 Martin Zvarík :
"SELECT * FROM xxx WHERE primary_id=123 LIMIT 1"
Is it useless (LIMIT 1) ?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
It doesn't do anything...you are already returning just
2009/6/3 Martin Zvarík :
> "SELECT * FROM xxx WHERE primary_id=123 LIMIT 1"
>
> Is it useless (LIMIT 1) ?
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
It doesn't do anything...you are already returning just the one row
since th
2009/6/3 Martin Zvarík :
> "SELECT * FROM xxx WHERE primary_id=123 LIMIT 1"
>
> Is it useless (LIMIT 1) ?
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List
On Fri, May 8, 2009 at 6:23 PM, Bogdan Stancescu wrote:
> Hello all,
>
> I asked this question on php-general last month
> (http://marc.info/?t=12404923034&r=1&w=2), and received some answers
> -- but I was directed to this list, so here.
>
> My question is: can I tell programatically whether
YVES SUCAET wrote:
Hi Chris,
I don't need 120 concurrent connections. The problem arises from subsequently
opening connections and the script is a way to simulate the problem: the
first
100 connections e.g. open up fine; then the next 5 mess up; then the next 7
are good to go again etc...
I'm u
basic PHP php_mysql.dll driver. I've used MDB2 from PEAR as
well: same result. I think both of these use the C API, and not the
ODBC-driver.
Yves
-- Original Message --
Received: Thu, 12 Mar 2009 04:30:33 PM CDT
From: Chris
To: YVES SUCAET Cc: php-db@lists.php.net
Subject: Re: [PHP-
YVES SUCAET wrote:
Hi List,
I'm experiencing the problem as described at
http://forums.mysql.com/read.php?37,39779,136287#msg-136287
I'm using the following script to test:
Results are very unpredictable. E.g. out of 120 connection attempts, I'll have
114 successes and 6 failures.
Well to
> error_log("Hey, the SQL is: $sql");
>
> Then look in your php error log (you do have error logging enabled,
> right?)
[McGovern, Dave] Enabled, yes. Usefully enabled, no (correcting this
helped a lot).
>
> If that SQL in the error log is fine, then your problem is
> $client2->multi_query
On Fri, 23 Jan 2009, dave.mcgov...@sungard.com wrote:
Hi,
I am running: PHP 5.2.8, Apache 2.2.11, MySQL 5.1.30 on Win32/XP.
I have a number of queries on my page which are very similar in
structure, and they all work except for the following one.
$mysql['process'] = $client2->real_escape_strin
Aleksandar Vojnovic wrote:
You could try with the <> operator.
!=, <>Not equal operator
Same issue as using '=':
mysql> select 2 <> null;
+---+
| 2 <> null |
+---+
| NULL |
+---+
1 row in set (0.00 sec)
Comparing anything with null returns null. (I'm not askin
You could try with the <> operator.
!=, <>Not equal operator
Or you could try it this way - ISNULL(col_or_data_to_check).
Example:
mysql> SELECT ISNULL(1+1);
+-+
| ISNULL(1+1) |
+-+
| 0 |
+-+
1 row in set (0.02 sec)
Aleksander
Chris wrote:
C
Chris wrote:
unknown compared to anything is unknown.
he was talking about plsql and condition evaluation (ends with true or
false), your point is absolutely useless.
The context is in the database - my example is in the database. How is
that useless?
In case you missed it, this is the con
unknown compared to anything is unknown.
he was talking about plsql and condition evaluation (ends with true or
false), your point is absolutely useless.
The context is in the database - my example is in the database. How is
that useless?
--
Postgresql & php tutorials
http://www.designmagic
Original Message
Subject: Re: [PHP-DB] MySQL Conditional Trigger
From: Chris
To: OKi98
Date: 8.12.2008 23:09
anything compared to NULL is always false
Actually it's null.
mysql> select false = null;
+--+
| false = null |
+--+
|
Fortuno, Adam wrote:
All,
Chris makes a good point i.e., "unknown compared to anything is
unknown". His comment made me want to clarify my earlier note. In my
earlier example, I wasn't suggesting that-that logic be coded in the
database. I was assuming it would be in the page:
I tested this,
o:[EMAIL PROTECTED]
Sent: Monday, December 08, 2008 5:10 PM
To: OKi98
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] MySQL Conditional Trigger
> anything compared to NULL is always false
Actually it's null.
mysql> select false = null;
+--+
| false = null |
+--+
anything compared to NULL is always false
Actually it's null.
mysql> select false = null;
+--+
| false = null |
+--+
| NULL |
+--+
1 row in set (0.01 sec)
mysql> select 1 = null;
+--+
| 1 = null |
+--+
| NULL |
+--+
1 ro
Monday, December 08, 2008 4:33 PM
To: Dee Ayy
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] MySQL Conditional Trigger
Original Message
Subject: [PHP-DB] MySQL Conditional Trigger
From: Dee Ayy <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Date: 31.10.2008 17:09
> I d
Original Message
Subject: [PHP-DB] MySQL Conditional Trigger
From: Dee Ayy <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Date: 31.10.2008 17:09
I don't think my trigger likes a comparison with a variable which is
NULL. The docs seem to have a few interesting variations on playi
Man- when the query is fired through the web interface- it rans on
mysql server
max_execution_time - wont' help evn I stop apache itself...
Yes it will. Apache will be instructed to stop execution of any script
by the mod_php module (assuming you are using mod_php). But mysql
process
Piyush Kumar wrote:
show full processlist ; gives me whole query -- but I want some php
function -- like mysql_info() -- to return the PID of last run query
Please do not email me directly. Always send to the mailing list.
If it's not listed under php.net/mysql somewhere, then it's not
availa
Piyush Kumar wrote:
Hi Chris,
As I mentioned in my query I want to Kill only the query ran by web
client not all queries running on the server.
The perl script kill all queries - which are been running from for
last 120(or any threshold set)
Issues:
How do I get the PID of my last select query
Man- when the query is fired through the web interface- it rans on
mysql server
max_execution_time - wont' help evn I stop apache itself...
The query runs on mysql server - so I have to kill the PID on server itself...
Thanks
Piyush
On Thu, Oct 16, 2008 at 7:57 AM, Jack van Zanen <[EMAIL PR
Just put the time out in your PHP.INI file
max_execution_time = 30 ; Maximum execution time of each script, in
seconds
2008/10/16 Piyush Kumar <[EMAIL PROTECTED]>
> I'm using http://myclient.polarlava.com/ as web query interface for mysql
> server
>
> Now I want to add "Query Timeout" functi
Piyush Kumar wrote:
I'm using http://myclient.polarlava.com/ as web query interface for mysql server
Now I want to add "Query Timeout" functionality to it
For that I need to get the PID for last ran mysql query and then using kill
PID - I can kill the process on MySQL server
Please explain how
TUDBC has recently moved to open-source GPL, similar to how MySQL
works. (You probably got the impression that it had proprietary
license, maybe because some the obsolete webpages still referred to
the old license, so I have corrected those obsolete web pages.)
I am not familiar with FOSS, but my
Until TUDBC is available under an accredited FOSS license, nobody in
their right mind is going to use it in any project that
may need to be ipr encumbrement free at a future date.
Posting solutions that pertain to a proprietary technology on a list
predominately dedicated to technologies tha
I kindly disagree. The original post asked "How to use OUT or INOUT
parameters of MySQL's stored procedures in PHP?" by STF.
To quote STF again in a later post "Yes, I've already found that
multi-step way before... I was just wondering if anything got better
since with regard to this. Apparently n
2008/10/10 Post-No-Reply TUDBC <[EMAIL PROTECTED]>:
> By using TUDBC (http://www.tudbc.org), you can call stored procedures
> easily.
Your post was an excellent answer to the question, "How do I call
stored procedures easily with TUDBC?" Unfortunately, that is not what
the original poster asked.
By using TUDBC (http://www.tudbc.org), you can call stored procedures
easily. Better yet, it works on any flavors of PHP (original,
Phalanger, or Quercus). Even better, you would use the same style of
coding for any DBMSes or programming languages. Have fun!
For an example in MySQL (just change th
Thodoris wrote:
I think that the manual is quite clear on this:
http://dev.mysql.com/doc/refman/5.1/en/call.html
You use a way to query the database like PDO or mysqli and you wite sql.
Yes, I've already found that multi-step way before... I was just
wondering if anything got better since wi
:
How to use OUT or INOUT parameters of MySQL's stored procedures in PHP?
STF
===
http://eisenbits.homelinux.net/~stf/ . My PGP key fingerprint is:
9D25 3D89 75F1 DF1D F434 25D7 E87F A1B9 B80F 8062
Little change - the label was not used in the right way:
http://pastebin.com/m2d98e677
On Sun, Sep 7, 2008 at 11:46 PM, Evert Lammerts
<[EMAIL PROTECTED]> wrote:
> I guess this code was not copy pasted from your actual source? It
> would generate mysql errors.
>
> Anyway, I think I've an idea of
Pastebin is so much nicer when posting code. Find the code i've sent here:
http://pastebin.com/mc5d611a
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I guess this code was not copy pasted from your actual source? It
would generate mysql errors.
Anyway, I think I've an idea of what you want, so here's my two cents :
function edit_cat_radio($item_cat_id) {
connect();
$query = mysql_query("SELECT * FROM cat");
while ($row
Micah Gersten wrote:
Anything Open Source? One of my friends uses SQL Server Reporting
Services and was wondering if there is a similar product for MySQL.
Don't know any off hand but check out sourceforge. Here's a couple:
http://sourceforge.net/projects/fourfive/
http://sourceforge.net/proje
Anything Open Source? One of my friends uses SQL Server Reporting
Services and was wondering if there is a similar product for MySQL.
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
Chris wrote:
> Micah Gersten wrote:
>> Anyone use one, hopefully written in
Micah Gersten wrote:
Anyone use one, hopefully written in PHP?
To report on what?
Or you mean something like crystal reports where you can make up your
own stuff?
crystal reports supports odbc so will be able to hook into mysql.
--
Postgresql & php tutorials
http://www.designmagick.com/
or NOT IN (0,4)
-- matt
On Fri, Aug 29, 2008 at 12:19 PM, Evert Lammerts
<[EMAIL PROTECTED]>wrote:
> In the SQL standard this would be
>
> AND NOT ministry_directory.listing_approved=0 AND NOT
> ministry_directory.listing_approved=4
>
> MySQL supports (and there are probably more RDBs that do)
In the SQL standard this would be
AND NOT ministry_directory.listing_approved=0 AND NOT
ministry_directory.listing_approved=4
MySQL supports (and there are probably more RDBs that do):
AND ministry_directory.listing_approved!=0 AND
ministry_directory.listing_approved!=4
On Fri, Aug 29, 2008 at
Hi Micah,
Thanks for help.
Best Regards,
Manoj Kumar Singh
On Thu, Jul 24, 2008 at 11:02 AM, Micah Gersten <[EMAIL PROTECTED]> wrote:
> You have to edit your my.cnf file. Here's a link to the docs:
> http://dev.mysql.com/doc/refman/5.0/en/log-files.html
>
> Thank you,
> Micah Gersten
> onShore
You have to edit your my.cnf file. Here's a link to the docs:
http://dev.mysql.com/doc/refman/5.0/en/log-files.html
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
Manoj Singh wrote:
> Hi All,
>
> Please help me to set the logging on in mysql. I am using the
> (i.e. stack_id > 500 && stack_id < 601 vs where stack_id = 500 limit 100)
stack_id between 501 and 600 (stack_id > 500 && stack_id < 601) is much
better
What I would like to know is if anybody has experience
implementing this sort of data structure in MySQL (linked list?) or
any advice.
list.
I said: you would get BETTER answers if you asked on a MySQL list.
De: Lasitha Alawatta [mailto:[EMAIL PROTECTED]
Enviada em: terça-feira, 26 de fevereiro de 2008 13:47
Para: Thiago Pojda
Assunto: RE: [PHP-DB] MySQL replication delaying issue
Hay,
BETTER answers if you asked on a MySQL list.
De: Lasitha Alawatta [mailto:[EMAIL PROTECTED]
Enviada em: terça-feira, 26 de fevereiro de 2008 13:47
Para: Thiago Pojda
Assunto: RE: [PHP-DB] MySQL replication delaying issue
Hay,
If U don't know about that t
On Tue, Feb 26, 2008 at 10:49 AM, Lasitha Alawatta <[EMAIL PROTECTED]> wrote:
> Hello Everybody,
>
> We have 6 multi-master MySql instances within a LAN , that are replicating
> is a sequential manner.
>
> Server Environment : Six identical Linux Enterprise version 4 running,
> servers with having
Maybe tell the list the exact solution?
File/variable/setting?
Cheers.
> I figured it out
>
> it was the mysql install not php :-)
> cheers for your help though :-)
>
> Vandegrift, Ken wrote:
> > You may want to check the my.ini setting for the table type you are
> > using and see if there i
M
To: Instruct ICC
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] mysql data truncation does not cause an error to
be thrown
Hiya
I could check the length of the field against the entry data and
javascript myself out of trouble but i was more worried that there is no
error or message when
ation sidestepped.
> Date: Thu, 8 Nov 2007 15:50:38 +
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> CC: php-db@lists.php.net
> Subject: Re: [PHP-DB] mysql data truncation does not cause an error to be
> thrown
>
> Hiya
> I could check the length of the
ation
Web Developer/Administrator
(Direct) 503-605-4132
[EMAIL PROTECTED]
-Original Message-
From: Andrew Blake [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 08, 2007 7:51 AM
To: Instruct ICC
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] mysql data truncation does not cause an error
Hiya
I could check the length of the field against the entry data and
javascript myself out of trouble but i was more worried that there is no
error or message when mysql clearly returns one saying i've truncated
this yet php ignores it completely. It should fail or know about the
truncation a
> Using mysql_query if i try to force more data than a field can have the
> data is truncated yet no error is throw at all.
> Is there a way round this ?
> Cheers
>
> Andy
This isn't exactly what you want to hear, but how about validating your input
before submitting a query?
John Pillion wrote:
this is bugging me to no end (no pun intended)... I am getting the error:
invalid query: 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 'Condition, ConstructType, BldgDimensions, Stories
Condition is a reserved word in mysql...you will need to change the field name
bastien> Date: Tue, 28 Aug 2007 18:11:20 -0700> From: [EMAIL PROTECTED]> To:
php-db@lists.php.net> Subject: [PHP-DB] mysql error...> > this is bugging me to
no end (no pun intended)... I am getting the error:> > inv
Chenri wrote:
Dear All
I'm running 3 servers with mysql database
- Local : 5.0.18-log, MySQL Community Edition (GPL)
- Main Server : 4.1.22-standard-log, MySQL Community Edition - Standard
(GPL)
- Backup Server : 4.1.20, Source Distribution
Not sure why you're surprised why they are differen
Hi
> I'm running 3 servers with mysql database
> - Local : 5.0.18-log, MySQL Community Edition (GPL)
> - Main Server : 4.1.22-standard-log, MySQL Community Edition - Standard
> (GPL)
> - Backup Server : 4.1.20, Source Distribution
>
> I copied a database from the Main Server to Local and Backup
From: "Instruct ICC" <[EMAIL PROTECTED]>
Why is this second log entry present? I don't see any place where I ask
MySQL to authenticate an HTACCESS username.
It came to me. The very fact that we are using mod_auth_mysql in the Apache
web server means that Apache is trying to authenticate anHT
Chetanji says,
This may be a typo of yours.
Look at the header...
CREATE TABLE `sometableo`
The 'o' is added by mistake?
Blessings,
Chetanji
elk dolk wrote:
>
>>Hi All,
>
>>I want to load data from dump file to MySQL table using LOAD DATA INFILE
>>but there is Error 1366 :
>
>>mysql> LO
elk dolk wrote:
Hi All,
I want to load data from dump file to MySQL table using LOAD DATA INFILE
but there is Error 1366 :
mysql> LOAD DATA
-> INFILE 'D:/SITE/SOMETABLE.SQL'
-> INTO TABLE SOMETABLE
-> FIELDS TERMINATED BY ','
-> OPTIONALLY ENCLOSED BY ''
-> LINES TERMINATE
I remember I had the same problem for the between dates.
for example, Select * FROM the_table WHERE the_date BETWEEN '2007-01-01' AND
'2007-01-31', the problem that it wasn't including the 2007-01-31, I
discovered later on that it should be something like:
SELECT * FROM the_table WHERE the_date B
Nice! That did the trick. Thanks Brad. I live to fight another day.
Tony
On 5/18/07 3:00 PM, "Brad Bonkoski" <[EMAIL PROTECTED]> wrote:
> Try using the substr, since you are only comparing the first letters...
> (sorry I did not reply all on the other email, Dan)
>
> i.e.
>
> select name from
Yeah, but what do I do for Q-Z? I guess I¹ll have to write a condition to
use last_name >= Q¹ if it finds a Z. I¹ll have to write conditions to look
for other exceptions too. Aaarrgh!
*looks up at the Gods*
Damn you BETWEEN! Why must you torture me so!?!
Have a good weekend.
On 5/18/07 2:51
Try using the substr, since you are only comparing the first letters...
(sorry I did not reply all on the other email, Dan)
i.e.
select name from users where substr(name, 1, 1) >= 'A' and substr(name,
1, 1) <= 'B';
-B
Dan Shirah wrote:
So just change it to WHERE last_name BETWEEN 'A' AND 'G'
So just change it to WHERE last_name BETWEEN 'A' AND 'G' . That'll get you
Aa-Fz :)
On 5/18/07, Tony Grimes <[EMAIL PROTECTED]> wrote:
We tried that and it didn't work. We've also tried every combination of
upper and lower case too.
Tony
On 5/18/07 2:18 PM, "Brad Bonkoski" <[EMAIL PROTECTE
We tried that and it didn't work. We've also tried every combination of
upper and lower case too.
Tony
On 5/18/07 2:18 PM, "Brad Bonkoski" <[EMAIL PROTECTED]> wrote:
> I think you need between 'A' and 'F%'
>
> Aa is between A and F
> but 'Fa' is not between 'A' and 'F'
> (but 'Ez' would be bet
1 - 100 of 1029 matches
Mail list logo