Not sure what to call what I'm attempting to do, decided on dynamic queries. I should mention that I've been working with databases for just a little over a month.
Example could be many web sites, but let's say Expedia (the travel site..booking flights, cars, etc) My understaning is that the SQL statements are contained in a recordset, but variables would be passed back into the sql statement based on the particulars of the user's input? Is that correct, is that the only way ? Further along, when someone wants to save a search , say like on Monster, is that done via a view or a "personal" recordset they can call too when needed? I'm reading around and trying to determine the best way. One last item, if my assumptions are correct in the passing of variables back to the recordset. In one of my tables, I have 5 different fields for say "dog types". dog1 dog2 dog3 dog4 dog5. Can I just use one user input field and then scan all 5 fields in the record ? Thank you, Stuart Sorry for the beginner questions. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
