Hi experts,
When i try to execute the stored procedure, he returns the following message: Conversion failed when converting the nvarchar value 'abc_20091016_0006' to data type int.
The data ...
Hi,
We have IIS servers (clustered via BigIP) in the extranet environment which is exposed to the external users, as per the application requirement, Anonymous access is disabled and only I...
Hi,
I have the below code. I want to remove newline characters and carriage returns for 'bodyText' before inserting into SQL database?
Please suggest with code.
Thanks
I want to integrate online realtime calculation of shipping charge in my shopping cart designed in ASP classic. I have seen such so many questions on this site , where in even Accepted Solutio...
I am in the process of putting together a new site. I have a few sections that are Java Script Based. What I would like to do is detect if the user has active scripting disabled, if they do, t...
I'm running an insert statement that is created by looping into the recordset and getting the column names and column values. In the code the SqlStmt has the insert statement created from the...
I don't know if this has already been asked, I wanted to run a classic ASP web page in Vista. It's showing a database error. The web page is running smoothly in windows XP.
The database co...
I've set up a virtual directory / web site in IIS 7 (localhost/mysite). I can navigate to it using simple html as well as ASP as long as I don't try accessing my MS Access database, otherwise...
I have created an ASP project that I want to be able to sort the 7 column fields by clicking on the name of each field name.
For example, the name of the fields are "Ad Number", "Date", "Ac...
I currently have a working version of ASPJpeg that allows me to take an image (already uploaded to the server) and create a thumbnail version of that image and store it in a separate folder on...
Hello, I am hoping someone can help me out!
I am working on an ASP project for recording and reporting stores' sales numbers.
The 1st page (NightlyStoreNumbers0.asp) has a date picker and a ...
I am preparing an on-line checklist for our server room. Application has been tested fine. However, we have one query which needs your help/attention. Is it possible to have "Conditional Foma...
Hello,
We have two setups in our development environment, same server OS running sql server 2005 and IIS 6.
I do my development on the development server, which connects to a test SQL serv...
Hi All,
I'm currently building a dynamic reporting tools for our stores, all is going well - my code is correctly building an SQL query to match all selections, retrieving the data, and put...
Here is my Database: http://www.caf-fca.org/en/reports/data.asp
Here is my code: http://www.caf-fca.org/en/reports/data.asp
Dear Experts,
I have a function like below
but now I want to check the other variables like mesaj,
I would like to check also Phone, Email, Address variables,
how can I add those variables...
Dear Experts,
I know that I asked really similiar question but ,
when I write it like this I have 28.09.2009 16:15:26
dim todaysDate
todaysDate = Now()
Dim F...
I need to have a bit of code that will detect if the user has came to my site with http://mysite.com or http://www.mysite.com
If they come from http://mysite.com then i need to redirect the...
hi..
I am doing domain name checker..
Below is the code of tutorial I get from internet.
But the result always return not available...
Who know what is the problems?
Thanks you...
B...
Hi,
We are getting this error several times a day when accessing ASP webpages on Windows Server 2003 in IIS 6 (on a FastHosts server). It seems to happen randomly and infrequently on all si...
Can anyone give me some advice on creating a login page using asp vbscript? I am using Dreamweaver as a development tool. I have experimented a little bit with the "on error resume next" but...
I have the following query
"SELECT * FROM tbl_News WHERE [newscat] LIKE '%" & varS & "%'" It works well however it brings up other variables that are not needed.
example newscat ...
Hello All
I am trying to format the date returned from a recordset. It's coming from microsoft access like this : 10/20/2009 11:52:02 PM
I am looking to write it out in the w3c standard...
I need to simply export all data from a database to a csv file. The only problem i'm having is i don't know how to handle special characters that are contained within some of the fields.
Sp...
Hey Experts!!
The query below works in Access but not in my Classic ASP application.
I keep getting the error:
No value given for one or more required parameters
SELECT DISTINCT Cli...