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...
Ahh, now that makes sense! However... I've tried this a few different ways and it doesn't seem to want to trigger the alert. My Flash variable is 'email'. Here's the code I'm using:
on (release) {
if (email == "") {
getURL ("javascript:alert('Please enter your email...
Hi,
I'm using Flash 5, and I've created a form for users of the website to fill in, then it posts to an ASP page for emailing to me. I've set up the ASP to check that certain fields are completed, such as name, email address etc.
However, I'd prefer a sort of alert box that appears within the...
It sounds to me like you might have the CPU protection features enabled on your motherboard. Quite a few of the newer motherboards give you the option of monitoring the CPU fan speed and CPU temp, and if the temp gets too high, or the fan isn't spinning fast enough then it'll shut of after a...
Yep all the new drivers installed. Didn't seem to be any conflicts so I tried setting up a new hardware profile.
What a brilliant idea! I just set up two new profiles, one for dial-up without the network card present, and one for network with both modem and network card. Now I just have to...
Hi all, here's a problem that's been bugging me for a while now...
I've got a D-Link DFE-530TX ethernet card for accessing a LAN when at Uni, but when I'm at home I go back to a dial-up connection for the Internet. I noticed that when I use IE (or any other app that accesses the 'Net) with my...
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.