Search results for query: *

Hi, i'm trying to find the start date & end date for a range of like data for example Turn this: ProductNo Date Price 12345 10/7/10 £1.50 12345 11/7/10 £1.50 12345 12/7/10 £1.50 12345 13/7/10 £2.30 12345 14/7/10 £2.30 12345 15/7/10 £1.50 12345...

Hi It there a way that I can send an email when multiple records are inserted to a table? Basically multiple record are inserted into a table and rather than bombard the users with emails for each record I was wondering if I could send a batch of inserts in a single email. All the record...

Hi I have only just started using Crystal Reports XI after using version 10 for the last 3 years. I'm having problems when creating a Date parameter of getting it to set the default value to the currentdate. (In version 10 if you left the default value blank it would automatically default to...

Hi all Bit of a basic question, but I have multiple trigger that I want to create to different table in one statement. Example CREATE TRIGGER rateaud ON [dbo].[exrate] FOR INSERT,UPDATE AS Begin ........ End CREATE TRIGGER forcastaudit ON [dbo].[forecast] FOR UPDATE AS begin ......... End...

I'm writing a Javascript slotmachine and was have become a bit stuck. I have 3 reels that display 4 images, I want to compare the images and if they match add a value to total amount won, but I am unsure how to do this correctly function spinem() { turns1=10+Math.floor((Math.random() * 10))...

I'm working on a traffic light system where users can input a time delay between light changes. The system is for 4 sets of lights each using its own thread process. I can start the threads but can't seem to get them to stop. the code is a bit rough at the mo Any ideas would be very...

Hi Is there such a way that you can use an IF Statement within an UPDATE Statement. Such as: UPDATE Table 1 IF col1>= 500 SET col1 = col1*2.5 ELSE SET col1 = col1*1.5 Thanks

Thanks for reading (more of a personal question than a professional one) I have just starting to use java and wanted to start writing a simple "Who wants to be a millionaire" java game. Using the few texbooks that I have i've managed to write a small part of the program, but I can't...