I need to allow user to save dataset to their computer in Microsoft Money
format. I searched internet for help on this but found nothing helpful. I
also chatted with MS Online Concierge to no avail.
If you could, please provide pointers to steps how to accomplish this. If
you will provide the steps yourself, please be very explicit in what you
provide.
how to do the conversion of data type varchar to money Code:
View Replies View Relatedi have a excel download which works fine, but the format is incorrect if i need to re-upload the worksheet to the database via a file upload.
so i think the problem is that in the download i am using a table format with <tr><td> etc. how can i change these to just be cell entries?
I would like to be able to allow the viewer of a website to download a file when they request it. Like seen at tucows or download.com
Can someone give me some rough pointers on where to get started?
I using ASP Windows 2003, i need in my web site, block files to download. if a user is logged, when download a file the direction of file save in URL, example:
http://mysite/files/test.xls
and any user get this file written this direction in URL, i like to block file or folder if the user is not logged.
The logging use session, and MySQL ...
We have to provide a facility on the client machines to download the data
visible on a ASP page into an excel sheet. We are using WIN2k clients
connected to WIN2k server with IE6.0 installed.
The way we plan to implement it is that :
a) provide a right click and download to excel button from the ASP page
visible in IE.
b) on click of download make a server call passing the appropriate command
to send back the data in excel format.
My questions are :
Q1) Is there anyway to avoid the server call? I am not looking for OCX
either?
Q2) Are there any issues to do with memory leaks / deadlocks in case we use
such office automation to generate a report in excel? Is there a way around?
Database procedure's condition -
IF i_as_on_date >trunc(sysdate) THEN
Database(oracle 8.1.7) date formate - dd/mm/yyyy
webserver data format (IIS5.0 hosted on win2k server) -mm/dd/yyyy
purpose - how to pass date's so that it both work in syncronised manner? can you write code of getting data format of webserver through asp page?
I want to get data in a specific format. For example i have 10 names in database and i want to show these 10 names in this format.
Name1 Name2
Name3 Name4
Name5 Name6
........ ........
....... .........
how it could be possible.
I want to get data in a specific format.For example i have 10 names in database and i want to show these 10 names in this format.
Name1 Name2
Name3 Name4
Name5 Name6
.. ...
... ....
how it could be possible.
I have a DB field (Access2k) with a field who's data type is "currency". If I do a plain ol'
numberVariable = rs.Fields("price")
the data is not formatted (ie: $9.50 becomes 9.5)
Is there a way to format the value in ASP, or to bring the field's data type over when querying a DB?
We are creating a multi-region ASP application which will be using SQL Server 2000. As our users exist in multiple location i.e. UK, US, Australia how can we distinguish that the date the user is entering is captured correctly i.e. no confusion with DD/MM/YYYY format.
I guess to remove database ambiguity I am going to use the format YYYYMMDD format but how do I know in the first place when the user entered 01/06/2006 that the user meant 1st June 2006 or 6th Jan 2006.
I've written many pages that emails the content of a web form, but the data
formatted very nicely. Is there a way to have the content of the submitted
form data via email in XML?
I have 2 table, tblCart and tblItem.
The structure for tblCart
CartID
Date
The structure of tblItem
ItemID
CartID
Name
a Cart containing several Items, it's one-to-many relationship.
I want to display Every Cart with the items in one webpage (ASP or PHP).
It would appear like Code:
i get some data from a session variable.(the session variable gets this data from another page).I want to display the data in a formatted manner.
View Replies View RelatedIs this possible to check if a text box on form.htm is in mm/dd/yyyy format before submitting to asp page?
if you enter say 2/2/04 it gives a incorrect date format error. The asp page uses this text box in the select statement for a db2 table query that is a date field.
I just want to ask if it is possible to output the data from "DataGrid" in MSWord or MSExcel format. If yes, How to achieve it?
View Replies View RelatedI will be eternally greatful if someone can provide snippet of code,
URL or reference material that shows how to display data in a "n
colums * n rows" format.
I am new to ASP and have looked everywhere that I could, but I have
not found an example where data can be formatted to be displayed in a
3 * 4 foramt, like many of the professional sites would do (actually
rows and columns can be any number of rows and columns) All the
examples that I have seen, show data displayed in a top down format.
How can I use ASP to read data in an Excel file and than write it in the format of XML?
View Replies View Relatedi have a field which has datatype as money
when i add a value in it like 110.00
rsadd("Amount")=txtamount
it comes like $110.00 which is right
what i want to do is instead of $110.00 i want -$110.00
i tried like this
rsadd("Amount")="-" & txtamount
when it added it came like this ($110.00)
How can I protect from SQL-injection in this instance?Code:
sql = "
SELECT dbo.admin.id, dbo.admin.email
FROM dbo.admin
WHERE dbo.admin.username = '"&Request.Form("user")&"'"
I have been thinking about storing some data, which my users upload, in text files rather than database, since often I do not know how much information users submit for things like item description or images URL paths.
This information may be very short or very long. MS SQL Server requires a maximum field length to be set. Thus, if user enters 5 characters into 5000 character field, a lot of space will be wasted. On the other hand, the database reference would point to the text
files to read users' data and display it on page.
how do i get data from a user on one page and display the result on the other page
actually i have written a prgoram that displays a set of checkboxes and based on the checkboxes selected the related data is displayed .but the problem is the data is displayed on the same page below the list of check boxes. Code:
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 having some trouble converting my varchar datatype to money. Code:
View Replies View RelatedI can't get the following code to display only two decimal places.
-------------------
ProductPrice.Text = String.Format("{0:c}", ProductDetail.Price)
--------------------
Can someone tell me how i can only show two decimal places and also how i can just show rounded to an integer.
I am inserting data into Access when user logs on:
..............
SQL = "INSERT INTO tblLog (fldUserName,fldTimeIn,fldSID) VALUES ('" & u & "',#" & session("Date") & "#,'" & session.SessionID & "')"
con.Execute(SQL)
.....................
in here it inserts the date :01/09/2003
But when logging out :
.............
SQL="UPDATE tblLog SET fldOffline=1,fldProper=1 WHERE fldUserName= '" & session("admin") & "' AND fldTimeIn=#" & session("date") & "# AND fldOffline=0"
con.execute(SQL)
...............
it doesn't update the record.If I eliminate the date query here,it updates there is no syntax error is there?
I am storing user entered form data from an ASP page in a MSSQL 2000 database. I would like to give my administrators a way to download a tab file with the entries. Is writing an ASP page the best way to do this? And if so, how can I convert database records into a file that will download through the browser?
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 RelatedWhat regular expression would I use to take out all of the money (US amounts) from a string?
Right now I have:
Code:
Set RegularExpressionObject = New RegExp
With RegularExpressionObject
.Pattern = "$(.*)"
.IgnoreCase = True
.Global = True
End With
xmlText = RegularExpressionObject.Replace(xmlText,"")
Set RegularExpressionObject = Nothing
which obeously doesn't work. What should I use for:
.Pattern = "$(.*)"
??
I want to know,
. Operation Behind the Online Money Transaction.
. If Once The client paid the money,
. How is it validated..( Credit Card)
. Also how Can the Admin of the Site will get the Money from the User.
i have a table which has many field, they go across and are named as a1a2a3a4a5a6-a16 the next row will be b1b2b3b4b5b6-b16 the last row is g1g2g3g4g5g6-g16 and so on.
now in the first column i.e which would be a1 b1 c1 d1 e1 f1 g1, the user enters a part number what i want to do is prevent him or her entering the same part no.
twice if this the case the two filds with same part no should be cleared.i.e if user enter p45 in a1 then p45 in d1 then both a1 and d1 should be cleared would be better if the later was only cleared but any method would do. Code:
I am developing an ASP application where the user may spend large amounts of time manipulating data on a worksheet. An amount of time that will certainly exceed the security mandated session timeout intervel of 15 minutes.
So the user pushes save after the session has timed out and is thrown to the user login window -- all according to standards. How can I either detect the timeout before the submit or preserve the user entered data despite the redirect?
I need to add and subtract transactions for each of our accounts
within our Access DB for account reconciliation.
Values found in our PdAmount field are either positive or negative.
Positive numbers are entered like $690.34
Negative numbers are entered like ($42.36)
I will use something like:
<%
Do until rs.eof
If rs(PdAmount) <> "" Then
'need function to check for positive
'if positive...remove "$" and add to total
'if negative...remove "(", "$", ")" and subtract from total
End If
Response.Write(total)
%>
Can someone give me a function that I can use?