Search results for query: *

I have a table that i have all pending tasks held in, there are many different stages with the innitial setup of a client record so there are many triggers on this pending table. It is already becoming quite a lengthy trigger, lots of if CODE = 100 insert this pending for run if CODE = 101...

ASP programmer trying desperately to program in t-SQL! I want to check if a certain record exists in a table when the trigger runs, just lacking the knowledge (and currently mental capacity as i'm ill) to find the answer. I have a pending table, as jobs are confirmed (deleted) i am setting up...

Hi, as my recent posts may suggest i'm just trying to get to grips with t-sql and i'm trying my hand at most sections. I am currently trying to get Sql to check my database once a month and setup new pending records accordingly. I've created my stored procedure, I even managed to schedule my...

Newbie to programming within t-sql but i'm slowly understanding it. My problem We are using an external piece of software but (with permission) are deveoping the back end to work more with our needs. When a new contact record is entered into a table I want it to check for a few things and on...

A little out of my league..... I want to write a trigger / stored procedure to run on a pre defined day of the month (ie. the first), every month. I want it to run only once a month checking information from a sales table and setting up records to a pending table if my criteria is matched...

sorry, this may be really really basic but my boss is off ill and i haven't worked with computer basics for ages. We've had a nasty system crash and now, due to no repair disks being created (again i claim no responsibility) i'm having to reinstall server 2000. previously the drive was...

Whatto all, Don't know why this is not working but, its really phasing me now! We use session variables a lot within our log in screens, we have many sites that all create session variables and are accessed throughout each site, except this one. I am creating the session variables within a...

From my main page i want to open a second window to accept further information. On the second screen it will accept the extra information. When second screen is closed / confirmed i want the table to be updated with the information, second screen to close and 1st main screen to be refreshed...

Not sure if this is the right place to post this but what the hey... Got a friend with a problem (haven't we all!) what they're trying to do is send an html page as the main text section (not attachment) through outlook to many people but is really struggling! on my machine at work we use a...

OS = windows95 problem = mouse fault A couple of days ago the machine was functioning normally with full working order on the mouse, i have now been informed that the mouse is not working, nothing has happened to mouse or board (so i've also been told!) but it won't work. In devices a problem...

Hello all!! I am doing some preliminary development on a new project, i came up with a brilliant idea to fill the front screen (theres not a lot to put in there) except I have just tripped myself up by trying to be too brilliant! The screen will be layed out as shown xx----Logo----xx...

I am trying to do a noticeboard, but calling it using java! It works fine, i've got an onclick refresh page with thread id=thread, I have a script at the bottom of the page saying if thread <> empty etc build variable (which consists of a grid getting values from an sql table) and then calling...

Is there a simple way to set the year in a date using ASP. I have a list of setup dates for each of our records, yet i want to refer to them as a month in the last 9 months. I have done this so whether the date was 12/08/1999 or 15/08/2001 they all come on the same list (easy) I also want to...

I have created a summary page to display totals for several queries such as, types of potato - 8 types of sweets - 10 and next to each one i have a kind of '>>' button which runs a javascript function to put the details for the selected item into a pre defined table i have in the center of the...

I have got some code that validates a string from an input mask, # for numbers, ? for letters & ! for everything else. Can anyone help me with the following, i originally posted this in asp and slowly realised i need javascript so i've sneaked in here! I'm going to use the function from the...

I have come across a problem concerning entry of data into my database. On the page in question I am taking ct references, vat numbers and other such references that are always entered in a specific way, ie. 3 numeric, space, 2 letters, space, 6 alphanumeric. Can i do this whilst it is being...

We have recently had a problem concerning our SQL server, not entirely sure what caused the problem but it happened around the time we installed some new software that uses the sql server as its back end. Previously we connected to our databases using oledb in our web pages using the server...

We installed sql with all default settings, using sa as our login! We have recently (thursday) installed some software that uses users in its own database to log people in. ever since i installed and started using this i have had problems with SQL ie. canot odbc to it, cannot oledb to it. the...

I'm using an asp page to send out information to our clients from an sql database, this has been working for a while.... Now some wiseguy in the company says, surely we should be able to mass mail timesheets etc to our clients. This on the other hand poses a bit of a problem, all the books i'm...