In an ASP page, I use the result (named y) of an external object (which has been called by server.createobject) This result, y, is an array of double (of size (n,1)). As it's not a variant, ASP send me an error (type incompatible) when I want to use it.
Is it possible to convert y in a variant type so that I can use it to make some computations in ASP ?
I want to be able to show prices in £ to UK customers and $ for every one else. Is there a way to do this.
View Replies View RelatedThe following code gets me the day of the month which I use in a query to give me all employees' birthdays for this period. But I have a bug: day variable used in the query must give me todays date(19),it gives me 21 (2 more than I want)
<%
dWeekStart = cDate(month(dWeekStart) & "/" & day(dWeekStart) & "/" & iYearToday)
dWeekEnd = cDate(month(DateAdd("d", 6, dWeekStart)) & "/" & day(DateAdd("d", 6, dWeekStart)) & "/" & year(DateAdd("d", 6, now())) )
sql = "SELECT * FROM bday WHERE maand = "&month(dWeekStart)& " AND dag >="& day(dWeekStart)
%>
I could really do with some guidance. I am currently hosting my website on a Windows Server, and use ASP pages for accessing MS Access database data and also CDONTS for forms to email.I was just wondering if I were to swap to Linux hosting, how easy or hard ( would it be to change these pages from ASP to PHP with the exact same functionality.
View Replies View RelatedI created a form to allow a visitor to add a new record to a database with the recordset object. Is there any conversion that needs to take place from the form input fields the user gives me to the recordset object? One of my form fields that I have is going to contain a money datatype in my SQL database and so far it's giving a 500 error.
My code in short looks like:
strCurrentPrice=Request("currentPrice")
then upon adding to the database the code looks like:
rsAddCards("currentPrice")=strCurrentPrice
I am calling a recordset from sql which happens to contain one column that is a datetime in the format: DD/MM/YYYY HH:MM:SS. So when I call that column from the db, it displays in the same format within my page.
However, I would like to be able to display the datetime as part of my recordset, but in a more aesthetically pleasing format (i.e: Sunday 1st May 2000, 7.23PM)
I have tried using the formatdatetime() function along with my rs, but this causes syntax errors. I know this is probably dead simple, but I don't get it!
I have a money datatype field in a SQL Server database.
I use the following method to take a value passed in the Request.Form collection and convert it to the double datatype:
cmd_AlloUpdateM2__incrdecr = Request("incrdecrA" & a)
cmd_AlloUpdateM2__incrdecr = replace(cmd_AlloUpdateM2__incrdecr,"$","")
cmd_AlloUpdateM2__incrdecr = replace(cmd_AlloUpdateM2__incrdecr,",","")
cmd_AlloUpdateM2__incrdecr = cdbl(cmd_AlloUpdateM2__incrdecr)
I keep getting a type mismatch 'cdbl' error on the line:
cmd_AlloUpdateM2__incrdecr = cdbl(cmd_AlloUpdateM2__incrdecr)
What's weird is I use this in other sections of my code and it works fine...no error. I've checked and re-checked the code and can't find the why this is happening?
How can I convert seconds to hh:mm:ss format? e.g. 123456s = 34:17:36
View Replies View RelatedAnyone have any code handy to convert a binary number to decimal and a decimal to binary? I need server-side code to perform these calculations. For example, I'd like to be able to pass 129 to a function and it will return 10000001. Likewise, I'd like to pass 10000001 to a function and get 129.
I can do this on paper, just not sure where to start on how to pass these numbers into a function to perform the calculation.
I am in UK using XP with date format set to dd/mm/yy. I am running an asp
site from a server in USA, which is returning the date from a database field
retrieved as objrec("todate") in US format mm/dd/yy.
To rectify this so as not to confuse visitors to the site I am trying to get
the date displayed as dd month yy , e.g. 25 January 04 by using the format
function format(objrec("todate"), "d-mmmm-yy"). This returns me a VBScript
runtime error "Type mismatch: 'format' "
The data base field "todate" is stored in short date format, which should be
OK shouldnt it?
My database is being converted from Access to MySQL. My question is how do I maintain the database once the switch has taken place? Are there freeware MySQL administration GUI's or something? I'm a little clueless here.
View Replies View RelatedI have never used dates in ASP or Access (due to being really new to both), but I have trawled the Forum and have come away even more than I started.
I need to input a date that the user puts on a form into a DB.
The DB field is set as a date data type with the format "short date"
Now when the user inputs data using my form everything is entered into the DB except the date
here is how I am trying to enter the date
If Request.Form("renewal_date") <> "" Then
oRS.Fields ("renewal_date") = cdate(Request.Form("renewal_date"))
End if
But it is not working. I am getting no errors it is just leaving the DB field empty.
I currently am using a script which submits full state names to a payment processor. However, the payment processor only accepts 2 digit state names. Does anyone have a premade code for asp that converts state names into 2 digit ones. Code:
View Replies View RelatedI have this code to check a valid date format in an ASP file: Code:
View Replies View RelatedI need to get data from database and convert it into HTML and PDF files.
View Replies View RelatedHave you any suggestion about components (dll, ocx, etc... freeware or not) that can convert file in PDF format through asp code?
View Replies View RelatedI'm currently working on a form that, upon submit, generates an RTF file. I've run into a little formatting issue. If you're typing in a text box, much like this one, and hit Enter to go down to a new line, nothing happens in the RTF coding. For me to have a text box Enter/Line translate into my RTF file, I need to replace it with /par . So, I know about the Replace() string function, but how can I make this work with a carriage return
View Replies View RelatedI am basically looking to create / incorporate some form of Auto-PDF generator into a website I am developing, essentially so I can set a webpage which I want it to convert.exactly in the same way that it works when you go to a Webpage then in the Browser you hit Print > and select Adobe PDF printer.This then creates a PDF identical to the webpage you are viewing
I seem to be hitting brick walls with this as I found one option which did this, but this did not support CSS, so exported the page on the fly, but with no formatting whatsoever.I then looked into ASPPDF but this does not allow for this
I have an mdb database and wish to convert it to csv format file i.e, comma separated version of text file with ASP.Can anyone help me soon.
View Replies View RelatedI have a number of HTML documents that I want to convert to PDF using a server component accessible from ASP.Can anyone tell me which component is the best and cheapest to use? It's a jungle out there
View Replies View Relatedim looking for some code that will convert an inputted amount in sterling to a number of different currencies.i presume i will have a text box and a series of radio buttons that a user will choose for another currency then a button to initiate the code to convert.
Could it do the currency symbol also? ie £ > $
I am currently generating a report in asp, which then needs to be exported to tiff format. How would I go about this?
View Replies View RelatedI want my site to show prices including VAT. How do I calculate this with vbscript. I also want users to be able to click on a button to convert the price to Euro/dollar/yen - how do I do this and can I use a live conversion rate without having to change it yself (eg get the current rate from a site to use tin the equations)?
View Replies View RelatedI do not know how to convert string datatypes to integer datatypes.
My problem is this:
num = request.form("number")
num is a String. I have to update num to columm named NUM which has a datatype -- long Integer. I have to turn num to integer before updating to NUM. But I do not know the conversion in ASP.
i just put up a web hosting service, the problem is its a linux this means it wont run ASP, he said its expensive to put up a windows server, and his server can only run PHP CGI but not ASP, is there any thing I can do? can i convert ASP pages to PHP?
View Replies View RelatedHow would the file below be translated in to ASP? PHP Code:
<?php
$string = "Kangaroos Rule!!!";
#Open file.txt with a mode of "W"
$fp = fopen ("db/file.txt", "w");
#Write $strink to the file
fwrite($fp,$string);
#Close file.txt
fwrite($fp);
?>
....
I have a job for a small ecommerce site that wants prices to be displayed in UK pounds, Dollars and Euros. Ive had a chat with a pal who says you can do it through RSS - tho i havent found a source yet! anyone know of a source or another way this can be done?
View Replies View RelatedI need to input into an Access database a string. My problem occurs when the string that I grab from an HTML form has a 'in it. I understand why it is doing it. However I do not understand how to fix it.
how do you grab a string from an ASP page such as: "Hello what's up" and place it into an database through ADO. The problem is the single quote. I know how to insert values into a database.
Code:
DIM mySQL
Dim start_week_1
Dim end_week_1
Dim date_param
date_param = "09/28/2006"
start_week_1 = date_param-(datepart("d", date_param)-1)
end_week_1 = start_week_1 + 6
I keep receiving the following error:
Microsoft VBScript runtime error '800a000d'
Type mismatch: '[string: "09/28/2006"]'
/Overtime/SQL.asp, line 43
I know that there is a conversion necessary. Possibly Cast(date_param as varchar),but that does not seem to work.
I am currently generating a report in asp, which then needs to be exported to tiff format. How would I go about this?
View Replies View RelatedI dump the entire recordset into an array:
If not rs.EOF Then
aEmp = rs.GetRows()
Contents of the array are in this order:
EmpID,EmpName,Indent,Sub_ID,Lft,Rgt,MgrID, LastName
This query sort on the basis of Lft and Rgt columns.
The name of the array is: aEmp.
My question here is how can I get only the LastName from the aEmp array into another array so that I can sort the names alphabetically and then display the employees in the alphabetical order.
Or is there is another way I could this by using the same array while keeping the lft and rgt sort of the query? If I sort based at the SQL query level, I can see the names sorted by the lft, rgt and lastname, but since the lastname is at the end of the sort list - it does not appear alphabetically.
In working with arrays, I have found that I am unable to dimension and array
with a variable that has an integer value but I can redimension one this
way. I haven't see any information that tells me if this is a requirement,
although it appears to be because I get an error if I try it.
Ex.
Dim b
b = 10
Dim a(b) ' this errors out but
Dim a() ' this
Redim a(b) ' works
Code:
I am developing an application in ASP and want to convert the reports to excel. Copy/paste does not work properly.
View Replies View Related