Search results

Hi all, Very long time no post. I'm working in a non-IT post at the moment but someone has asked me to do them a favour! OK I know I shouldn't strictly embed images in HTML emails but that is exactly what is required. I need to be able to send an email to 100 users on our internal network via...

Hello everyone, How do you all deal with + and & when sending info to an ASP? Some of our Reference fields contain + and/or & When the user enters a ref containing + eg SMITH+1, SMITH 1 is sent to the SQL server stored procedure. When the user enters a ref containing & eg SMITH+1, SMITH is...

Long time no post. The guy who took over from me has been a bit silly. He was in a 'test' database and deleted some records from a 'test' table. Problem is, he was in a live database. Instead on admitting it, he's gone off sick and is bricking himself (he's just rang me). Where do the deleted...

I know the single quote issue is well documented throughout t'internet but I can't find reference to my particular problem. I have also read up on SQL injection. I have my data and stored procedure in an SQL 2000 database. I have an HTML page with 2 input boxes - 1 numeric and 1 text. The 2...

Sorry about this but I need your help. I am looking for a way to return the number of rows from a select query to a variable in vbscript. I can get a value to return but it's not what I want. I get 1 if the SQL returned any Rows and 0 if it didn't. I am using a RETURN VALUE parameter in my VB...

Hello all. This is a cry for help. Here's the scene. Our Agency has a very simple retrieval tool written in Access 2000. The client is on the local PC and the back end is on a server. The back end consists of 8 databases (one for each year) and the contain records of all transactions (around 3...