|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Test Posted by A at 4/30/2004 10:50:34 PM Test
...more >>
job sql server don´t work Posted by Mikael Hellström at 4/30/2004 8:21:18 AM Hi, im running windows 2000 and sql server 2000
I have added a job to my database on a 5 minute run schedule.
The TSQL statement you can find below
DELETE FROM online
WHERE (DATEDIFF(n, tid, GETDATE()) > 25)
But it don´t fire at all. Any now why?
Regards Mikael
...more >>
Generate csv file from sql table Posted by ththomps at 4/30/2004 7:21:03 AM I am looking to do the following from a C# ASP.Net applicatio
1. Generate a DS from a SQL pull of a single table. Once I have pulled the data (Display to user is not required, just notification that the data has been gathered)
2. Convert the DS to a .CSV format and place the file in a directory w...more >>
ASP SQL query question Posted by Brandon at 4/30/2004 5:27:10 AM Greetings,
I have a question about a database query from an asp page. My query is
functional and produces the data that I need; however, one column
contains a numeric value that I need to translate to a name. For
example, the number 1 needs to show up as "VZE" on the loaded web page.
The seco...more >>
INSERT MAX(ID) Syntax problem Posted by Targa at 4/29/2004 11:32:21 AM Trying to get the ID (autonumber) of a record that has just been inserted
and insert it into a different table but I either get a syntax error or a
data type mismatch. Ive tried switching the Sched_CustID field type to both
number and text. I think it has to do with my quotes or double quotes on ...more >>
Time question - add 15 minutes Posted by Digit24 at 4/29/2004 11:30:49 AM I have a time field in an access database and I want to be able to add 15
minutes to it.
I can do this manually by taking the minute, adding 15 and then if it is
over 60, changing the hour, but is there an easier way like with adding a
day to a date by simply adding 1?
Many thanks
...more >>
Using Invalid Characters Posted by Jay at 4/29/2004 9:59:50 AM I am using MS SQL for my ASP application and have several 'comments' fields.
Obviously in these fields users are going to enter invalid characters and
when they try to submit they will receive an error message. How can I deal
with these invalid characters so the information they are trying to sub...more >>
user_id as session variable Posted by JT at 4/29/2004 9:22:25 AM the application i'm working on stores user_ids as a session variable. many
stored procedures throughout the application accept this user_id as a
parameter. the problem is that often times a user's session will expire
without them knowing it (like if they left their browser open for 2 hours
wit...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Database Connection Question Posted by christiancooper77 NO[at]SPAM hotmail.com at 4/29/2004 5:20:10 AM I have a question for you, it involves IIS and database connections.
When I got hired, we were using an asp include file with database functions
and would open and close the database connection multiple times in 1 script.
Common sense dictated we should only open the connection once, get all...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |