Search results for query: *

Hi when i run this sql i get this error The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. The statement has been terminated. The ASP ("INSERT INTO offer(OfferCode, OfferPercent, OfferStartDate, OfferFinishDate, OfferDescription) VALUES...

Hi i have a function which i am including on multiple ASP pages via an include file and is been called on multiple pages. However i wish to run a little bit of logic if a particular variable exists. however i dont want to have to go through and declare the varible on all my pages or remove the...

Hi i wish to only display the top 10 distinct 'SearchStr'. How can i do this as i have to display the 'SearchResultid' in the Select statment to get the OrderBy to function. This is my current SQL: SELECT DISTINCT TOP 10 SearchStr, SearchResultID FROM SearchResult WHERE...

Hi i have an issue calling stored proc from ASP i can run this proc fine in Query Analyser. For some reason it wont run in my ASP. There is no error message it just wont update my table as i would expect. I have done some response.write in the code so I know its getting to this point. any...

I have a stored proc with a basic query which is returned as a recordset. However there are certain circumstances where the recordset may return no records. In which case i wish to execute anouther SQL db query instead. I wish to implement the 2nd query in the same stored proc how is this...

Hi am working on a small e-commerce website which was written in ASP and written by a database programmer. I am familiar with Dreamweaver and am try to detangle the HTML so I can more easily make design changes to the website and ultimatly so i can make the website W3C complient. However i am...

Hi i get this stupid error in my code on line marked in red Operation is not allowed when the object is closed. (Just after i open the connection!) Dim rs, cmd Set rs = CreateObject("ADODB.Recordset") Set cmd = CreateObject("ADODB.Command") With cmd...

Hi we have Full Text Search set up on our web server which works fine. I am setting up a test enviroment locally and i cannot get the full text index to function. I have imported a copy of the database. In Enterprise Manager under full text Catalogs it still lists the old Full text catalog...

I know this is got to be basic but i cant understand why this stored proc errors. Procedure or function usp_ParentCatChildWeightUpdate has too many arguments specified. /category.asp, line 572 This is the ASP it errors on the ,,adExecuteNoRecords line. with cmd 'response.write...

i got excited when i read somewhere about the existence of computed columns in SQL Server. This is because i like using binary bitwise numbers to uniqely identify rows within my database. So I tried creating a table and creating a fomula which calculates a unique binary mask fom the shippingID...

Hi i have a stored proc which has three Sql queies in it. 2 of the queries i am outputing as output parameters. The third query i output as a recordset. I am having trouble because i have circumstance where the result of one or more query brings back no result sets. This appears to result in...

Hi i have a stored proc which has three Sql queies in it. 2 of the queries i am outputing as output parameters. The third query i output as a recordset. I am having trouble because i have circumstance where the result of one or more query brings back no result sets. This appears to result in...

Hi I have a large T-SQL proc which normaly retrieves a recordset from the DB which i then display the results within my Application. I wish to output @TotalWeight (even if i get no results within the main recordset). How do i do this? CREATE PROCEDURE [dbo].[usp_ShippingOptionsGet]...

Hi i am fairly new to stored procs and get an error on the line DECLARE. Can anyone point me in the right direction? ALTER PROCEDURE [dbo].[usp_ShippingOptionsGet] @ProductsWeight int, @CustomerID AS DECLARE @ShippingArea Char(3) SELECT @ShippingArea = Countries.Shipping_Area FROM...

Finaly got the right forum I have created a very basic stored procedure which displays Shipping Options based on geographic location. The unique identifier is a three character letter field called 'GeographicalCoverage' For example bellow works fine and retrieves all records from the UK as i...

I have created a very basic stored procedure which displays Shipping Options based on geographic location. The unique identifier is a three character field called 'GeographicalCoverage' For example bellow works fine and retrieves all records from the UK as i would expect: SELECT * FROM...

I have created a very basic stored procedure which displays Shipping Options based on geographic location. The unique identifier is a three character field called 'GeographicalCoverage' For example bellow works fine and retrieves all records from the UK as i would expect: SELECT * FROM...

Hi i wanted to find away to do an update using a Join between three tables and i was strugelling until i stumbled accross this in the frequently asked questions. faq183-1958. However now i get a syntax error when i try and verify the SQL. any ideas? Incorrect syntax by the word AS. UPDATE...

Hi i am a newbie to SQL and creating a a proc in SQL 2000 where i wished to link data from two tables i want to retrieve both a default section to link from tblcategories and a non-default (multiple) section from tblcategories. I have decided the easiest and most flexable way to this would be to...

Hi i have the following code which is styleing a series of buttons. However i wish to change one of these to a text link so that search engines can more easily spider there way through i still however need it to look identical to the other buttons. Can anyone advise as to the best method or...