if my month is represent by numbers. like 2, 4, etc
i recognize this as a string but then i want to store it as int
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting the varchar value '2, 2, 2' to a column of data type tinyint.
/ords/asp/custorder_view.asp, line 41
u can see the varchar value to colum of data type tinyint
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'm passing a unique identifier from page1 to page2 to page3 querried from MS SQL Server. When I pass the value, it puts the value in the curly brackets. (Page1 is for display and Page2 is for edit and Page3 is update edit)
When I go to Page3, it gives me an error saying "Syntax error converting from a character string to uniqueidentifier" {7171B9BD-4599-43D9-9521-3DA583A1BB1A} This is the value and the error page says "id=%7B7171B9BD-4599-43D9-9521-3DA583A1BB1A%7D" It seems tp put "%7B" and "%7D" for "{" and "}". Has anyone seen this?
I'm also passing numbers and text and they don't seem to have this problem, just the unique key.
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).
View Replies View RelatedThis is the code for my Procedure:
Code: .....
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.
View Replies View RelatedI have never run into this problem in the past. I am getting the following error:
Syntax error converting the varchar value 'Power450' to a column of data type int.
On this line:
Set grabProduct = siteConn.Execute("SELECT infoProductName FROM tblProducts WHERE infoProductID = " & distProductsArr(x))
When I output that to the screen, it shows up as:
SELECT infoProductName FROM tblProducts WHERE infoProductID = 9
The infoProductID field type is int and the infoProductName field is varchar.
We have just upsized an Access database to a MSSQL database, our website is built using ASP/VBscript and we used to use the following SQL statement:
SELECT *, (link_url &'?ID='& ID) AS NewURL
FROM dbo.menu_mnu
WHERE visible_mnu = 1
ORDER BY order_mnu ASC
Which doesn’t work with a MS SQL database so we changed it to:
SELECT *, (url_link_mnu +'?ID='+ id_mnu) AS NewURL
FROM dbo.menu_mnu
WHERE visible_mnu = 1
ORDER BY order_mnu ASC
However this gives this error…
Syntax error converting the nvarchar value 'link.asp?ID=' to a column of data type int.
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've tried cast(bill_priceA as money) and I get
Microsoft VBScript compilation error '800a03ee'
Expected ')' Code:
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.
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.
View Replies View RelatedI 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.
I'm having some trouble converting my varchar datatype to money. Code:
View Replies View RelatedI 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....
View Replies View Relatedhow to do the conversion of data type varchar to money Code:
View Replies View RelatedI'm working on a page so that a user can change their password. I thought might be a simple update of a database, but everytime I do it I get the following error message. I've put x's where my ID would be showing for security purposes. Code:
View Replies View RelatedI've got a varchar field in a database that I need convert to a datetime field in my database. I'm trying to use Convent, but get an error (the select statement is huge, so I'll just post the convert portion - the select works until I put the convert in)
SELECT Convert (astra.EVNTINST.START_DATE AS datetime), astra.EVNTINST.ID ... WHERE astra.EVNTINST.START_DATE BETWEEN '10/1/2006' AND '10/31/2006' order by astra.EVNTINST.START_DATE, astra.EVNTINST.start_time, astra.EVNTINST.id desc
When I add the convert, I get Microsoft OLE DB Provider for SQL Server error '80040e14' Line 1: Incorrect syntax near '.'.
To call the value, I'm just using:
Response.Write mymonth("START_DATE")
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 am doing this asp programming with vbscript and came across to this problem. i need this answer asap coz i have to submit my assignment tomorrow. the thing is in the code below all the condition under the if statement works EXCEPT where i want to say that 'OrderValue' has to be between 100000 and 999999 inclusive.
it doesnt work i hv used to 'CInt' function to change 'OrderValue' Integer 'OrderValue' contains the text/string entered from the previous page that was entered in a text box called 'txtSearch'
is any way possible to convert a string, which is a string of a number, to an integer (using VBScript). If not, are there any other solutions to have a number that is a string, and add one to increase that number?
View Replies View RelatedI am trying to populate column values from an Oracle database into an HTML "Select" control. The column in the databases is defined as number. It is not working because I think I need to convert the value from the databases into a string variable first.
View Replies View RelatedI need some advice in converting a line of string into array. For example; "001,002,003,004,005,..." into 001, 002, 003 and so on. How can I do this?
View Replies View RelatedIs there any function or some code to convert string to unicode directly or ( string to ascii and then ascii to uniccode ).
View Replies View Relatedi got some text fields im submitting by a form and i need to add the field to the current field in the table but the field is text in the table so when i do this
request.form("dkp1") + getraids.fields.item("dkp1").value
i have dkp1 = 10 from the form
and 20 in getraids field
and the above calculation it dosn add but puts them to getter as a string like 1020 and i need to calculate it to 30. my real question is there a way u can define the request.form(dkp1) to be converted from text to numberic ? and getraids of course or do i realy need to change the field type in the table ?
Am collecting numerical entries from text boxes and converting to numbers using:
F1 = Round(CDbl(Request.Form("amout1")),2)
F2 = Round(CDbl(Request.Form("amount2")),2)
F3 = Round(CDbl(Request.Form("total")),2)
F4 = F1 + F2
If F4 <> F3 Then
Session("ErrorMessage") = Session("ErrorMessage") & "- Your control amounts do not tie to the Total Deposit amount.<br>"
End if
etc.
Sometimes it works, but other times, although the numbers tie out, the calculated amounts are not coming up as equal. I've written the results (F3 & F4) to the screen and they equal, although the server doesn't think so.
Is this an issue with binary number conversion or something. Should I be using something other than CRnd (Delphi has something like C$ or CCurrency)??
I have the following stored procedure:
CREATE PROCEDURE [dbo].[GET_CategoryCurrentNewsList]
@Category VARCHAR
AS
BEGIN
SELECT dbo.News_Joined.NewsTitle, dbo.News_Joined.NewsID
FROM dbo.News_Joined
WHERE (dbo.News_Joined.StartDate <= GETDATE()) AND (dbo.News_Joined.EndDate >= GETDATE()) AND (dbo.News_Joined.CategoryID IN (@Category))
END
GO
dbo.news_Joined.CategoryID is an INT, and @Category is a string such as (1000, 1010, 1020). However, no results are returned. I figured I had to do something to do some string conversions from INT to VARCHAR or something, but I can't use CSTR. I do not know how many numbers will be passed to @Category, so making seperate variables isn't an option.
Any ideas???
I am having terrible time in converting a string to a datetime field in my asp page. I am keep on getting error on the following stateement. What would be the correct syntax on converting string to datetime for inserting into a sql table?? I did write the add_str out on the browser, everything looks correct...
Error message:
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting datetime from character string. Code:
I'm using Msxml2.ServerXMLHTTP.3.0 to fetch a HTML page on a remote
server. The fetched page is then parsed and the information of interest
is extracted and send to the client browser.
However, the remote server does not specify any character coding in its
headers. If using ResponseText property in ServerXMLHTTP, some
international characters are not decoded correctly. This is due to
ResponseText assuming UTF-8 coding if no character set is specified.
My solution is to use the ResponseBody property which returns the web
page as an array of unsigned bytes. I then convert the data to a string
using the ADODB.Stream method as described here:
http://www.motobit.com/tips/detpg_binarytostring/
The string is then parsed and the required information is pulled out.
This solution works just fine but I wonder if there is some more
efficient (without the need for a byte to string converion) way to
solve the problem.
i need to convert a string to hexadecimal prior to posting it onto the next page...how do i pass the field value to the function prior to posting ? Code:
<%
Function StringToHex(str)
' conversion here
End Function
%>
<html>
<head></head>
<body>
i hope my doubt is clear. i tried looking in the posted forums couldn't find anything . Anyone know how ?
im trying to input some data into a database from a text box to a field with a text data type the problen is when i try to input "44/22" it goes into the database "2"
so it makes the math process
so how can i fix this to insert the 44/22 into the database ?
I've got a string that contains commas and semi-colons to be used as delimiters. It looks like so: 1,1;4,2;
I'm trying to write a function that will turn similar strings into a multidimensional array, but I'm having problems.
Code:
Function fncCreateMultiArray(strString, strDelimiter)
arrOneDimension = split(strString, strDelimiter)
For i = LBound(arrOneDimension) TO UBound(arrOneDimension)
arrTwoDimension = split(arrOneDimension(i), ",")
Next
fncCreateMultiArray = arrTwoDimension
End Function