Search results for query: *

Hi, I am currently sending a HTML newsletter from an ASP application using the script below. I have used this in many applications with no issue however I am now facing a problem that when the HTML content (which I have validated by printing to the screen) is sent using the .send command a...

I am building a Bobby A accessible site complete with ecommerce which means I can not use any javascript on the site (or more accurately I need to ensure all functionality works without Javascript enabled). The problem I have is that within the ecommerce process I am calling a stored procedure...

I have a function which is insterting a record into a table and then using SCOPE_IDENTITY() to return the newly created ID for that table. This all works fine untill I call the function within a loop, then the SCOPE_IDENTITY() returns a NULL. Does anyone have any idea why this is happening...

I have a database with a category table built using the child/parent relationship, the system users will have access to specific products related to these child categories. Once I have identified the products they have access to I want to build a navigation bar to only inlcude the category the...

Hi, I have a dynamicaly generated HTML email which is being sent to our clients, part of the email displays current revenue generated by the client in their local currency. The currency symbols are populated from an SQL table. This works fine for all currency's including the Euro symbol when I...

I have a directory of word documents on my server which have been uploaded from my website.. I need to be able run keyword searches over the documents, is there anyway I can do this? Thanks in advance!

Hi, Hopefully someone can help me here, I have a stored procedure which is running a bulk insert statement to copy records from a CSV format file into an SQL server table. This has been working perfectly well until recently, the code has not changed but the operating system on the server has...

I am currently using the ContentType = "application/vnd.ms-excel" to export a dynamicaly created report into excel. My question is, is there anyway to prompt the user as to whether they want to save the excel document or launch it. I have seen this before but am not sure if its down to...

From within a stored procedure I am trying to detect whether a table exists, however the table is in a different database to the SP, I have tried using the following code but this only works where the table and the SP are in the same database... if exists (select * from dbo.sysobjects where id...

Ok, a Javascript simpleton requires help.... I have two form fields, startDate and endDate which are formatted as follows; startDate - 'December 03' endDate - 'March 04' I need to compare these fields within javascript to see how many months have been selected... All responses welcome, I...

I am passing three comma deliminated fields to my stored procedure, the first of which contains codes, the second two contain dates pertaining to the codes in the first. They are all in order, is there a quick way of matching up this data into a temp table so I get on record for each code...

I have a multi select drop down box which for style reasons I have limited to 30 characters. However, some of the text which appears in there is far greater that this. Is there anyway that I can get the full description to appear when I hover over the entry. .. I have tried using the <span...

I am trying to insert a list of id's into a text column in a comma deliminated format. The list is coming from the ID's of another table. Is there anyway I can do this without looping through the table and building the variable with ',' and then updating the result table? I was hoping that I...

I am currently producing a number of reports in ASP built via stored procedures. Basicaly, each stored procedure will build a temp table of results dependant upon the parms passed from the ASP page. I then return these results to the ASP page and format the results to get the report to look how...

HI, Is there any built in function within ASP that will allow you to sum all the elements in an array or do you have to loop through manualy?

I am currently trying to dynamicaly build a number of <div>'s which I want to sit sideby side each other as layers over the main page. I am having two problems, I want to use the float:left property so that they will automaticaly position themselves to the left of each other, however this only...

Hi, Are there any known efficency problems with calling a stored procdure from another stored procedure? I am currently doing this to collate the information I require for a report and it is taking 26 seconds to run. I don't believe there is enough data being sifted to account for this so I was...

Hi, I have the following coded in an SP which I can't seem to get to work. Basically I am passing a varchar field to the SP which will contain a number of logon ID's in comma seperated format.. ie. '32,76,43,22'. I then need to check for these values on the Logon file which stores the...