Search results for query: *

Greetings Double T'ers- I looked up and down in the forum for an answer to my question to no avail. Alas, I am stuck with a fairly routine problem and hope to get some expert advice from you. Here is my issue: I would like to take a record in table, called 'table1' and move it to another...

Greetings- This may be really simple, but the answer skips me at the moment. I would to add the value of the "ID" column from the main table "tblMain" into another table called "tblRandom". I just cannot seem to get it to work. I am wondering if it has to do with the identity seed in the main...

Hello- I was wondering if there is a method in which one could set a time limit on the alt attribute on an image. For example, if I have a really really really long alt image attrubute the alt text will only stay open for around 8 seconds. Is there a way I can change that to 30 seconds? Any...

Hello! A very easy answer, but... I really have been beating my head against the wall trying to figure this out but for the life of me i cannot! Here is the deal: I have an intranet application which requires endusers to login with their username and password. the username and pword are...

Greetings- I must create an application with the option which allows end users to upload files to a SQL database. Instead of storing the file in the database itself, I would like to have ASP create the URL where the file will reside on the server, and also upload the file itself. My queston is...

Greetings everyone- I have a question I would love to get advice on. I have a recordset with a few very looonggg urls which push the lengh of the table out and I was wondering if there was a way to add a line break either via ASP or within the stored procedure to add a line <br> break after...

greetings- is there a way to extract specific information from a function? For example: Function FindTOTAL_OPEN_123 FindTOTAL_OPEN_123 = FindOPEN_ALA + FindOPEN_ALA_CAT2 End Function Say I wanted to count the number of records in this function which had a value of: store_id = 123...

Greetings- I am in the process of moving a DB from Access to SQL for an application and one column holds an OLE OBJECT in the access db, which converts to Image datatype in sql. I am not sure if I would like to hold the images, zips, docs, etc inside the db as it seems to bloat the db...

greetings- I am trying to run a query which will count the number of records in a table but just cannot seem to get it working! The background is this: If a record is active, it has a 'Status' of '1', if it is pending, it has a status of '2'. What I am trying to acomplish is to get a count of...

good day- I am trying to export a report from an asp page to an excel file but I'm having some difficulity formating the cells in xls. I am exporting with the <% Response.ContentType = "application/vnd.ms-excel"%> method. There are two tables in this report and each has different width...

Greetings- Happy holidays. I am creating an application which updates a DB and I am getting the following error for a reason unknown to me: Microsoft OLE DB Provider for SQL Server error '80040e14' Line 1: Incorrect syntax near '='. add_stepB_NEW_SQLtest.asp, line 52 line 52 = Set...

Greetings- I wanted to ask anyone and everyone what they consider the best practice for passing session variables. I have a situation in which i need to pass two variables ( a Start Date and End Date) in a SP in order to capture records between those two dates. Would it be best to add the...

Greetings- I am trying to calculate a difference between arrays which have been defined (and work!). I have one array which counts the total: qryPri = "SELECT Count (Entry') as prnRecs FROM tblInfo WHERE... " Then, I have about 10 other queries which count specifics in the total, such as ...

Greetings- I am trying to write an error handler using an If/Then statement in order to prevent the below error in case the value is zero. The idea here, is to determine the MTTR (Mean Time to Repair) in a table on an ASP page. I have the formula working, but when I select a start and end date...

Greetings- Happy holidays to all who read this. I am having a problem with trying to query a table to get all entries between a start date and end date (query is below) I am using macromedia dreamweaver mx and upon entering the info into the recordset window and testing the query I get the...

Greetings All- Happy holidays! I'm running into a bit of an issue with a variable being passed via querystring to return results from a SQL db. I continue to get a : Microsoft VBScript runtime error '800a000d' Type mismatch: '[string: "SELECT COUNT (*) CAS"]' error when opening this page...

greetings- Hello there!! Thanks for looking at my post :) Here's my dilemma: I am trying to display database (SQL2K) results based on a stored procedure. The results to be displayed, should only calculate data between a start date and an End Date. These two dates are set by our friend "End...

Greetings- I am having a tough time writing a stored procedure which will return results between a Start Date and End Date from a form. Simple Question: How can I do this? I have a stored prodcedure which returns the results of the column in question, but it returns ALL of the results. How...

greetings- I am trying to define a DSN-less database connection with a connection string but appear to be getting a different database with a similar name. I check the string and everything looks fine (string below). It is pointing the the correct DB, but displaying info and contents from...

Hello- I am trying to add a feature to my websites which will allow usrs to create an area which will store their prefered areas of the website. For example, if a user only went to my site for a specific area or page, I can gather this data and allow the user to jump to those paages from the...