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 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.
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'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'm developing an Asp.NET system to take a CSV file uploaded via the web, parse it, and insert the values into an SQL database. My sticking point comes when I try to split() the string returned by readline() on the file.
The following code snippet works for me:
tokens = "one,two,three,four".Split(",")
for each token in tokens
response.write("<td>"+token+"</td>")
next
However, if I take the next line in the CSV, read using StreamReader.ReadLine on the PostedFile.InputStream, I receive "Object reference not set to an instance of an object." which I have narrowed down to be my string holding the line. Further investigation reveals that no other string member functions work on my line (.ToCharArray, .ToString, etc).
I suspect that StreamReader.ReadLine is not correctly returning a string, even though Response.Write(line) displays what I would expect .....
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?
View Replies View RelatedI'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?
View Replies View RelatedWe are evaluating a clients request for converting their existing site using cgi and flat text files to ASP 3 and Access.
The site displays: their products that are broken down into sub categories, guest book, and a survey.
I am only "aware" that text files can be imported into Access but have never done it.
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 have an existing application in asp. I need to add new functionality can I do using ASP.net ?
View Replies View RelatedDo we have any function in ASP that will convert US time(which is captured in the database) to IST
View Replies View RelatedMy 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?
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.
View Replies View RelatedI have a project to do that requires that I use mysql as the database. I have only used MS Access. The sql will be simple searches.
Is there a drastic difference, or just different punctuation?
Can I find a copy of mysql on the web? If so, is there any advice on installing?
I am trying to get values from our database which are in a single field, into seperate variables.
I have a field called locations, with multiple values example... "East Sussex, London & Home Counties, Scotland"
I would like to get each of these into seperate variables e.g.
variable 1 = East Sussex
variable 2 = London & Home Counties
variable 3 = Scotland.
I guess it will need some sort of regex to detect number of commas, then a loop or something.
To make things slightly easier, none of the values in the locations field have commas inside them.
While I've used Access's export function in the past to generate ASP from
the tables, I wonder whether there's anything around to do a more
comprehensive automatic conversion. I've noted a few ads for such products,
and I wonder/hope there's some experience around here that might be shared -
with recommendations.
I am using XMLhttp and responsebody to receive info from a webpage
I dont use responsetext since i need the international chars едц
The information I recieve is binary is there any fast way to convert the
binary data to text ?
I used this function but its slow compared to response.binarywrite
and i need the information in a string so I can alter it with my script.
So is there any way to convert Binary to Text just as fast as
response.binarywrite ?
Function BinaryToString(Binary)
Dim I, S
For I = 1 To LenB(Binary)
S = S & Chr(AscB(MidB(Binary, I, 1
Next
BinaryToString =
rtf files cause so many troubles,i.e.,allow the users to download the files, slow loading,incompatible with other browser, and so on. Do you think I should convert them to JPEG files to embeb them into HTML?
Once converting JPEG,it is easier to programming in HTML(i.e.,just add the image tag),load faster,and prevent the user from download the files?
how to convert a date in (tuesday,may 17,2005) to a date in(17/05/2005) format. is it possibleto dowith the helpof formatdatetime() function. if possible how ?
View Replies View RelatedI have a form with multiple text fields, when i submit the form i want it to edit a table in my database using UPDATE. I know i have the syntax correct. The problem I have is 2 fields are Currency and 2 are Date. The request.form command always returns a string and i keep getting the 'Data type mismatch in criteria expression' error. How do i convert the strings to dates, and strings to Currencies.
View Replies View RelatedHow do I convert this into something that I could read into an HTML email? I can string regular text but have NO IDEA how to convert syntax for a checkbox into HTML.
Can anyone give me some direction? My code for my checkbox is below. The msgBody is the string I'm building to send in my email. Code: