Search results for query: *

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...

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...

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...

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...

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...

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...

Hi, I'm trying to figure out a way of posting a form to a popup. It's just a poll form that posts to an ASP page, but I'd like the page to open in a popup. Here's a cut down version of the form I want to post: <form name=&quot;poll_form&quot; method=&quot;post&quot...

Hi all, I need a method of calculating the number of days that have elapsed between two dates. It's to work out the amount of fines payable on an overdue book. So for example, if someone takes a book out that is due back on 02-May-02 (the data format using Oracle's sysdate) and brings it back...

Hi! Just a quick question... Please can you tell me the operator/function I can use to slice a string down into a certain number of characters! eg If I only want to display two characters of the word hello so it comes out he. What do I use to do that? Thanks a lot for your help!! :-)

Hi, I've written a timer that is pretty simple and uses a thread to increment seconds, then sleep(1000), to wait 1 seconds then loop again and increment a seconds again. This thread just runs in a while loop. I use a System.out.println to print out the result each time the loop runs through a...

Hi all! Here's my prob (it seems kinda silly cos it's so simple): I wrote a very small script that uses the ASPUpload object by Persits (http://www.aspupload.com). It's pretty basic, and just allows you to upload to different folders on the server, and it does that well. However, I'm trying...

Hey all, I'll just set the scene: I've written a number of smallish ASP scripts, most of them I developed for my own website, so I give them away for free. However I recently wrote one for my site which was my biggest yet. I've added a big admin part to it as well so it can be easily...

hi all, Just a quick one; does anyone know where I can get the sound effect of a movie projector (y'know the sound, that sort of clicking sound). I've searched high and low on the Net, including flashkit.com and other sites as well as google.com etc but to no avail. Can anyone help with this...

Hi all, I'm using IE 5. A couple of times I've got to a website where good 'ol Norton has popped up a Virus Alert message and halted everything. It says the page I'm viewing contains a virus called JS.Exception.Exploit. What is this Virus? I was thinking it might be an Active X control of...

Hey all, I've been trying to sort out some code for rating articles. I'll try my best to explain: Each article can be voted for (1-5; 5 being best). The vote script I wrote does some calculations based on the number of votes and the score which returns the average score (to about 8 decimal...

Hey all! Someone asked me about bookmarking their site. They want it so that when you bookmark the site from any page you're on, the bookmark will always take you to the main homepage. IE, if you're here: www.mysite.com/news/item1.html and you bookmark it, it'll bookmark...

Hi all, I've got two questions for you guys so I hope you can help me: Firstly, I have written some nice simple ASP code that just reads from a database. For example, it just uses the query: SELECT * FROM Jokes and this displays the joke title and put the link in which when clicked reads the...

Hi, I used to use a dial-up connection to access the Internet and use outlook express to download my emails from a POP3 server. No problems there, it all worked fine regrdless of the Dial-Up service I was using. However I've just hooked up to a network and so the Internet outside of the...

Hi, I've written a small ASP script where all links that link to sites outside of mine go through my ASP script (external.asp) and the script then takes the URL and puts it into a lower frame whilst in a top frame I have my website logo and links to some of my pages. Simple so far. The...