Looks like a good way of doing it - thanks! I sorted it about 10 seconds after posting using the syntax:
SELECT * FROM Newsletter WHERE (VisitorCountry='DZ' OR VisitorCountry='AS' OR VisitorCountry='AD') AND ( VisitorPhoneType='Alcatel BE3' OR VisitorPhoneType='Alcatel BE4' OR...
Hi,
I've been going over and over this but can't see the syntax error. Here's the query:
SELECT * FROM Newsletter WHERE VisitorCountry='DZ','AS','AD' AND VisitorPhoneType='Alcatel BE3','Alcatel BE4','Alcatel BF3';
The error I keep getting is: Incorrect syntax near ','
Any ideas what is...
Hi,
I installed XP a little while ago and used Windows Messenger to sign in with my Hotmail account. The problem is, whenever I open MS Outlook Express 6 it automatically signs me into messenger. I've set the Options in Outlook Express so there's no check in the "Automatically log on to...
Woooohooo! I've got it all sorted! Was a bit weird at the start cos it couldn't install at first (jumped out saying it couldn't read/write to C drive), so I disabled Norton Antivirus and whoosh (er, that's the sound of Windows installing)! Great stuff! Thanks a lot!!
OK, I've installed Partition Magic Pro V7.0, and had a good read of all the documentation with the prog and on the web site. I'm almost ready to roll except....
I've got a 40gb Hardrive, and 10gig's already full with win 98 stuff. I tried resizing the partition so that I've got about 10gig...
Hey thanks guys, I might see if I can 'aquire' a copy of PM (er, well it's being 'aquired' as I write this ;-)) so I'll see how I get on with that. Thanks again!
I've got Win 98 SE running, but I've just 'aquired' a copy of Win 2k Pro. I wanna run the two on different partitions (I'm thinking FAT32 and NTFS, but should I go for just FAT32 for Win 2k as well??).
Thing is, I'm not sure where to start. Without splashing out on any extra software, how do...
Ah yes, brilliant stuff thanks! I tried the javascript method which works great! And now the the new windows open at that size (I'm running at 1024x768 but need an 800x600 window for testing my websites for those resolutions). No more faffing around resizing it! Thanks! Have a star each!
Hi, I'm running IE 5 (still) on Windows 98SE (still!) and was wondering if there was any way of adjusting the default size of the IE window when you open IE. For some reason when I open it now, it's only about 300x400 until I maximise it or change the size manually. The window used to open at...
Ahh, solved it! Just used "quantity" + the item id to identify each field and used a for loop to loop through 'em. Got there in the end anyways.... ;-)
Hi,
I'm developing a shopping cart system and it's all working fine except one bit I'm stuck on...
When you've added something to your cart it displays the details and quantity. The quantity is displayed in a textbox so you can change it and hit the update button so the form posts the new...
I've gotta say MySQL would be a great db for your purposes. Pretty much free, seems to run really nicely on Windows platforms and I've have some big success with MySQL and ASP working together. While I'm at it, I've also gotta recommend MySQL Front if you're setting up a MySQL db. It's an...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.