an a 2 character INT field and populate it with either 0
(no) or -1 (Yes) then you can get them to work quite well. I'm sure that
some guru will have a better idea than that!
What sort of stuff are you doing?
Craig shepherd
-Original Message-
From: Chris Becker [mailto:[EMAIL PROTECTED
where records also start with B.
For example it would return
A
Allan
Anderson
Appleby
B
But I want it to return
A
Allan
Anderson
Appleby
B
Black
Brown
Butterworth
Has anyone any ideas?
Thanks in anticipation
Craig Shepherd
]
Subject: RE: BETWEEN... LIKE query
* Craig Shepherd
select * from consumers surname BETWEEN '$surname_from' AND
'$surname_to'
assume $surname_from = A and $surname_to = B
would only return results where the surname is A or greater but
less than B, but I would like to include all
Using UltraDev 4 with Phakt 1.2.1, linking to a MySQL server 3.22.23
I want to develop a SQL SELECT query where I can vary what customers are
listed depending on the value of various form fields.
For example if the check box surname_all is ticked then all customers are
displayed if not then it
= WHERE surname between $surname_from and $surname_to;
} else {
$surname_query = ;
}
-Original Message-
From: Craig Shepherd [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 10:55 AM
To: [EMAIL PROTECTED]
Subject: Dynamic SQL
Using UltraDev 4 with Phakt 1.2.1, linking
InterAKT produce a Dreamweaver Ultradev extension called Phakt that is
pretty good. It creates PHP scripts that manipulate MySQL databases. It is
free and allows comparable functionality to the 'native' UltraDev languages
(ASP, JSP, Cold Fusion).
For more info -
InterAKT produce a Dreamweaver Ultradev extension called Phakt that is
pretty good. It creates PHP scripts that manipulate MySQL databases. It is
free and allows comparable functionality to the 'native' UltraDev languages
(ASP, JSP, Cold Fusion).
For more info -
