My data input page uses a id generator which includes dashes, and the
corresponding column in the db is set up as varchar to handle that.
There is a problem, however, when the value in the varchar column is
compared to the string from the URL, and the following error message
occurs:
"Syntax error converting the varchar value '071-213' to a column of
data type int."
<%strSQL = "SELECT * FROM AMS where MinutesID = " & Request ("id")%>
Would it be possible to CAST the request string to varchar?
The problem I am having is that I am trying to insert data from a form into a DB, but I cannot figure out how to change the form value (varchar) to the db value (money).
I am repeatedly getting the error message 'error converting datatype varchar to bit'. I am passing a varchar variable to a stored procedure (where it is also a varchar) and then trying to write it to a table (where it is also a varchar).
I'm using ASP, VBScript, ADO for SQL server 2000. I have a stored procedure that I'm trying to use to insert a row using parameters. One of the field is date. Here is the parameter for that. Code:
Set param = cmd.CreateParameter("theDate", adDBTimeStamp, adParamInput, Date()) cmd.Parameters.Append param
But I'm getting this error. Error converting data type varchar to datetime.
When I execute this code, I receive this error on line 314: [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to int. Line 314 is the classComm.Execute line. All the datatypes in my stored procedure those specified in the parameter declararations, and they all match with the datatypes in the DB. Other than the strings that are integer (strClassID) or date (strOccurDate), everything is a varchar.
I have no idea why this error is occurring. I have a similar stored procedure that adds the records in the same way and it kicks out the same error at the same time.
there is an old asp application that is moved from one machine to the other.On the one machine its working fine, but on the new one, when trying to insert from the asp page(variables from the asp page), i get this error, Error converting data type varchar to datetime.
I have tried almost everything, from checking the order of variables, but still get the error. When the proc is executed on SQL it runs fine, am i maybe missing something?
I have migrated ASP pages and SQL SERVER database from a development server to the Live SERVER the regional settings are fine both set to use UK date dd/mm/yyyy. But I have that stupid error when I try to run a stored procedure EXEC sp_add_user 1,'28/08/2004 10:00:00'.... on the live server and not on the development one. I dont want to redevelop all my stored procedures.
I have a 3 page set that searches a database for users, displays the user information in a form and updates the data in the database. The first 2 pages work fine, the third page doesn't. What is annoying is that these pages are a copy of another set of pages that edit news articles (basically the same thing) and they work perfectly.
This is ASP with SQL and VB Script.
Quote: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E07) [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting the varchar value '6, 6' to a column of data type int. /d1intranet/useredited.asp, line 72
So this message is saying that it is unable to UPDATE the field 'UserName' (which has data type INT) with the variable in the SQL code which is default as VARCHAR. Here is line 72: Code:
I keep optimizing my fields down to the minimum character length necessary i.e., varchar(15), then I find out a month later its gotta get bigger, then a few months later, bigger again, etc. Nowadays on sql server 2005 and on, how bad is it really to use varchar(max)? Is there really a big performance or storage hit or is it negligible?
ive got a form which takes in someone's age. request.form("Age")
and then using a stored procedure i want to stick that age into a table in my DB (SQL server) The data type of the table where age goes is type int. So when i run my script to grab the age from the form it tells me :
I have a field "Description", varchar2(100). When I try to show it on the HTML/ ASP page from a recordset, it appears as "word+word+word", nevertheless I have no "+" in the field.
I was wondering if any one could help, I've been looking on the net and can't seem to find any. how do you convert varchar to int, I'm trying to do an sql statement and it chucks up errors.
I have a problem with submitting data from one form to db in sql server. Data type of that field in DB table is money (the other is for varbinary data type) and in asp I have an textfield <input type='text'....>. After submitting I get the next error message:
"Implicit conversion from data type varchar to money (or varbinary) is not allowed. Use the CONVERT function to run this query."
I need to compare two values. one from a text field 'bid' and the other from a field in an sql server database 'maxbid'.
The problem is the column in the database has decimal as its data type and i'm getting a type mismatch. does anyone know how to convert 'bid' into decimal from varchar? the field datatype doesnt necessarily have to be decimal although i need two decimal places so it cant be an int.
If I have a SQL 2000 database with a table that is using 2 Ntext fields with a lot of data in them, can I convert them to VarChar(8000) fields safely? Will there be data loss? Would it best be done through Enterprise Manager?
I am updating information in an SQL database through a form and I need to convert my varchar string into the money datatype in my database. Can anyone help me with the syntax? Here is the code....
I need to use varchar(max) for my out parameter (@resultText) from the 4000 length it is currently using. When i change the length to -1 or drop it altogether i get an error, how can i fix this issue? Code:
I have read that there can be a periodic problem when reading large varchar or text fields from SQL server (or memo fields from Access)--they can sometimes come up as empty strings.
What I have been unable to find out is whether this problem is still around in recent versions of MDAC (>= 2.8). Does anyone know whether this problem still occurs--is it still necessary to follow the steps in that aspfaq article?
I am using two fields on a form to capture time someboby is working. The fields are hours and minutes. How can I when submitting to the db take both fields and convert them to a single field in the db as minutes?
I'm looking for a control to us on our web site that will take our reports that are generated in PDF and convert them to DOC format all on the server. We are using win2k3 web servers if that helps.
I have developed an access database with VBA. Right now its on a network drive and is shared by 75 users. Works fine.
Now I would like to have this in the company intranet. Is it advisable to go with ASP? I recently installed IIS in my system. After that I have no idea how to convert my application to ? Is there a website or any walk through how to get my stuff's solved.
My application has 20 input screens, data add, save, update and also sends email based on certain rules. Is it possible to do all these stuffs?
I want to convert CSV file to XLS. Is there anyway this can be done in ASP without renaming the file to XLS.Also can there Macros to Sort data in it while generating XLS?
I have some PHP scripts that need to be converted to ASP3 so that they can run on a Micrsoft NT server using ADO. My knowledge of ASP is limitied so i was hoping you could answer a few questions..
1. Is ADO part of ASP.net or is this completely different? 2. Is ASP3 the same as ASP.net? 3. Is there any advice you can give me regarding converting from PHP to ASP3?
I've stored a set of months in an access database as numbers but when it display on the front end I need it to display as the name of the month.
How would you convert the numbers in the database to their word equivalent? Or is it possible to arrange the months in their correct order in the database?
I am passing a string into a page and them looking up info to display from a database based on whats passed in. The link is www.domain.com/page.asp?variable='12345678' Once inside the page the following code is executed Code:
i want to convert asp file to excel sheet through asp application. iam having report.asp file as a view form i need that form to convert in excel sheet can you help me.
