RE: MySQL and MSAccess
Haven't done a great deal of this but it does work pretty well. Obviously connection speed is a bit of an issue especially where you are dealing with INSERTS into several linked tables from a form. I couldn't find an equivalent field in MySQL for the Yes/No type in Access so it you create 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]] Sent: 11 March 2002 20:08 To: [EMAIL PROTECTED] Subject: MySQL and MSAccess Anyone using MySQL on Linux/Unix with a MSAccess front end? Using odbc bound controls? Any issues, insights, suggestions? How's the interaction with the Jet engine? Any performance issues? Thanks in advance. Chris _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
BETWEEN... LIKE query
Hi, I have a form with two fields surname_from and surname_to, I want to be able to do a select query where the results will lie between these to values. That's easy enough but I also want to include all results where the record field (surname) matches the first part of the fields - in effect a BETWEEN query incorporating the LIKE function. For example 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 records 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: BETWEEN... LIKE query
So if I did something like
$temp = $surname_from.{;
select * from consumers surname BETWEEN '$surname_from' AND '$temp'
it should do the trick?
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]]
Sent: 05 March 2002 11:49
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
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 records where records
also start with B.
Append a high ascii value to the $surname_to, like '{', so that your query
will be:
select * from consumers surname BETWEEN 'A' AND 'B{'
--
Roger
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Dynamic SQL
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 displays all customers where the surname lies
between surname_from to surname_to.
I couldn't find an appropriate way of handling this in MySQL directly so my
aim was to determine the SQL portion outside the query and then append it to
the query:
if ($surname_all == -1){
$surname_query = WHERE surname between $surname_from and $surname_to;
} else {
$surname_query = ;
}
NB - If $surname_all = -1 then it has been ticked.
And then I would declare my SQL statement as
SELECT * from customers.$surname_query
UltraDev doesn't like this and so I would appreciate any help in either a
better way to code it in UltraDev or a SQL statement that would achieve the
same aim.
Thanks for your help
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Dynamic SQL
Thanks for that.
It's actually more the UltraDev/Phakt thing I'm having problems with. I just
wondered how you would set the SQL statement in such a way that UltraDev
wouldn't complain - it doesn't like SELECT * from customers.$surname_query.
Do you know of a good way of handling conditional statements in MySQL?
-Original Message-
From: Trelfa, Jonathon [mailto:[EMAIL PROTECTED]]
Sent: 04 March 2002 16:34
To: [EMAIL PROTECTED]
Subject: RE: Dynamic SQL
Try using something a little different:
if ($surname_all){ //checks to see if the variable is set
$surname_query = 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 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 displays all customers where the surname lies
between surname_from to surname_to.
I couldn't find an appropriate way of handling this in MySQL
directly so my
aim was to determine the SQL portion outside the query and then
append it to
the query:
if ($surname_all == -1){
$surname_query = WHERE surname between $surname_from and $surname_to;
} else {
$surname_query = ;
}
NB - If $surname_all = -1 then it has been ticked.
And then I would declare my SQL statement as
SELECT * from customers.$surname_query
UltraDev doesn't like this and so I would appreciate any help in either a
better way to code it in UltraDev or a SQL statement that would
achieve the
same aim.
Thanks for your help
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL PHP Development IDE
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 - http://www.interakt.ro/products/PHAkt/ -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: 21 February 2002 14:58 To: 'Joel Wickard'; [EMAIL PROTECTED] Subject: RE: MySQL PHP Development IDE There is three options I use: 1. Macromedia Dreamweaver UltraDev4 with a PHP plugin or extension 2. PHPEdit, its free I forget the website. ItÂ’s a good IDE, but kinda annoying editor. 3. Notepad -Original Message- From: Joel Wickard [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 10:34 AM To: [EMAIL PROTECTED] Subject: Re: MySQL PHP Development IDE This off topic, but one of our programmers is interested in NuSphere's PHPEd development interface and I would liek some feed back from other users. His interest lies not so much in using for database table modeling, but for PHP and Perl development. If he's not really that interested in the mysql integration than I would say that you could probably go with a different IDE. PHPed's db integration and built-in php debugger are about the only two things that set it apart from other IDE's. I am well aware of the conflict a few months ago between MySQL and NuSphere, but I have never heard anything one way or the other about PHPEd. At nearly $500 per package, it is not a decision I wish to make without some feedback from the community. How does PHPEd stack up compared to other PHP IDE's? What experience (good or bad) has anyone had with it? Is there another product that is better? Any feed back (either to the list or me me privately) will be appreciated. Before you make a commitment, you can apply for a trial version of PHPed. You have to give them real contact information, (I think I've gotten like 5 sales-pitch emails since I downloaded my free trial 3 months ago.) So you can give it a shot before you buy... and at $500 you should probably try it first. As for feedback on experience with the editor: When you try to install the editor (at least this was what it did three months ago) It wants to install it's own copies of Apache and MySQL. kind of un-handy if you've got current installs you want to use. I think it gave you the option to keep your own, but after I got everything installed, the database integration wouldn't work. So I decided that I had free time on my hands, I hosed my installs of apache and mysql and let it install it's own stuff. after that I still couldn't get it to work properly. I probably could have tweeked something here or there and gotten everything to go, but my reaction was kind of like.. I'm going to pay $300 to have to play with it this much to get it to work? It just didn't seem worth it Given that I currently used allaire's homesite and the only things that PHPed had over that in features was the db integration and php debugger, and I had already worked out my own solutions to those problems. I recommend downloading the trial version before you buy. I also recommend downloading the trial version of homesite as well. Homesite gives you syntax highlighting, project management, web deployment. scriptable deployment wich lets you decide what gets sent, where it gets put etc... all in a script that you can re-run. Plus homesite let's you edit the ide to add in features that you may need (http://www.macromedia.com/software/homesite/) Or look into Quanta depending on what platform you plan on developing on. I found it ironic that if you buy PHPed standard, it only runs on windows platforms, and that if you decided to buy PHP advantage, then you get linux support. seems like it should be the other way around given that the product they are trying to sell was built on the back of Open Source technologies. Gerald Jensen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check:
RE: MySQL PHP Development IDE
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 - http://www.interakt.ro/products/PHAkt/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
