Get Current Rates
i'd like to know if their is a way to get current rates to use them in an asp script that makes currency conversions?
View Replies
ADVERTISEMENT
Speed Rates
my asp pages use mysql db...i got 40 tables.
mostly the site system uses 7 tables only...
in the past i used access mdb database but after this 5 tables fulfilled with something like 10000 records it was so slow i could read a book before it moved...
then i moved to sql...
now the question is for who had/have asp pages connected to mysql with more than 50,000 records...
how is the speed? can you see the speed diffrence with the growing of numbers of records?
if i got slow speed when i ask my asp pages to show me some records, is that because i got more than normal number of records inside one table?
80,000 records inside one mysql table sounds to you normal?
Shipping Rates
I'm developing an e-commerc website and now that I am
working on the shipping portion, I wanted to know what is
the best way to get shipping rates so that they always
appear current on your website without using any
components.
Where Can I Get UK Mortgage Rates In Xml/rss?
anyone know a source of uk mortgage rates for different providers in one feed?
View Replies View RelatedConversion Rates And Vat
I 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 RelatedUPS Rates Online Tools
I am trying to integrate UPS's Online Tools into my classic ASP project. Does anyone have some examples of this that I could look at? I am specifically looking for information on the "Rates and Service Selection" tool.
View Replies View RelatedCalculate USPS Rates
Has anyone seen a decent script for getting USPS rates live in your own shopping cart?
View Replies View RelatedRecordset To Only Contain Current Items (i.e. If Date Of Item Is Past Current Date)
I have a noticeboard that the user inputs items into. One of those is the date of an event. Once that event has passed I want it to disappear from the page.
So I need to do a comparison with current date to the date in the "datestarted" field. My table is called "notices." Using Access and ASP VBscript.
Get Current Url
Im trying to get the current url where the user is at and store it into a variable. I want this to be done automatically, not when a user clicks a button. Any ideas?
View Replies View RelatedGetting Current URL
a way to get the current URL AND the variables in it, all in one command? There probably isn't, seems to simple, right?
View Replies View RelatedDisplay The Current URL
I'd like to know how to display the current URL on the web page as a footer. This seems to be a fairly simple task, but everything i've found on the internet either doesn't work for some reason, or is asp.net specific....
View Replies View RelatedRead Current Url
Is there a way that I can read the current url.
I have an asp page currently such as default.asp?x=1&y=2&z=3
Now I want to keep the existing parameters and attach another parameter
to it and resend to default.asp
As the original parameters are dynamic, and may or may not be
generated, the only way is to read the current url and to simply add my
new parameter such as h=5 to the url.
I don't know how to read the current url.
I tried Request.ServerVariables("SCRIPT_NAME") but that didn't include
the parameters. i.e. it just returned the default.asp
Current Connection
Does anyone know where I can find information about Reading current
connection value from performance counters into ASP page. I wanted to
know how I can call the current connection value in my ASP page
Current Page
how to print or get the name of current page using ASP
View Replies View RelatedUsing ASP To Get Current Page
I'm not sure if someone has requested in the past (I know I've looked for a solution for a while) but I've just developed a very neat way of getting the current page name in ASP:
url = request.ServerVariables("URL")
page = right(url, len(url) - instrrev(url, "/"))
I've finally found a use for the instrrev function
Current Record ID
I've created a form whereby the user fills in there details into a datbase.Once there details have been entered into the database I want to show the Primary Key(there generated ID number).This is the code I have right now
<%
SQLQuery = "Select * from StudentReg"
Set GetDetails=MM_dbconnect_STRING.Execute(SQLQuery)
%>
<%=GetDetails("ID")%>
This however will only show the frist ID number in the database, not the one the user just entered. How do I get the current ID within the new record?
Current Grade
To cut down on maintenance,I'm tracking 500 or so students via their graduation year, rather than their current grade,so I don't have to go in every summer and ratchet up all the grades.
I need to allow the teachers to search for them based on grade(9, 10, 11, or 12).So what I need is to be able to compare the grade chosen on any given day of the year,and have the code figure out what grad year that person is in, assuming a constant of the 4 year plan, and do a SELECT * WHERE gradYear = 2009
The problem is that I could take the nowYear or something, but that changes half-way through the school year (stupid northern hemisphere) and I'm stumped on how to compare more complicated dates.
Get Current Date
i need a button or a link, that when clicked on, grabs the current date. It then puts this date inside a textbox.
View Replies View RelatedGetting Current User In ASP
How can I query the current user logged on to the local machine and store the username, the first name of the person, and the last name of the person in variables?
View Replies View RelatedShow Most Current PDF
I have a ASP page that when a user clicks a link it uses a DLL to stamp a .pdf with a watermark and then display the .pdf in there web browser using the Adobe Reader. This all works fine.
if a user views a pdf and then modifes it if they click the link again it still shows the old version of the file. They have to hit there refresh button to show the changes. How can I make it so my page always displays the lastest version of the PDF and not what is in the cache?
Current Page Url
How can I retrieve the current page url(and parameters/arguments) using ASP code? The current page is an asp search results page so the url includes the page name and the criterion(sorry I don't know what they're called) I had the 'post' method tag on the end.
I need to get it and store it so I have an easy way of getting back to this page at a click of a button a few pages down the track. I've tried using location and history but I'd like to manage it myself.
Current Recordset
ADODB.Recordset error '800a0cb3'
Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype. I am moving my webserver from NT4 using SQL to win2003 using SQL 2003. I get the above error when my asp page does teh line:
Rs.absolutepage = intCurrentPage
I tested teh value of intCurrent page and teh value is 1. Any ideas? The .asp Page works perfectly fine on teh old machine.
What's The Current File
Thingy to call to figure out what the current file is (ie: index.asp)? I thought it was request.servervariables("something") but just can't find it .
View Replies View RelatedGet The Name Of The Current Page
is there a command in asp to get the name of the current page?
furthermore, is there a way to retrieve the name of the current page within
an 'included' file (not the name of the included page, but the name of the
page that is including the file)?
SQL For Current Date
I am coding an ASP page and need to know how to pull the current date.
Here is my code:
SELECT tenant_id,fname + ' ' + lname as [name],
FROM TENANT
WHERE start_date < [TODAY'S DATE] AND [TODAY'S DATE] < end_date
URL Of Current Page
I am using an include for a navigation bar, This nav bar appears on many different pages and the help facility a button on the navigation barneeds to launch a help box relating to the page it is included in.
The help files are .html but the file names relate directly to the asp page in which the navbar is included. To get the javascript in the navbar to correctly display the correct help window, I need to get at the page name. I am using
dim thisPage
thisPage= request.ServerVariables("URL")
This will hopefully return me the full file path of the page that the navbar is included in. I then need to take the filename out of this URL and remove the .asp from the end so that i can use it in my javascript function to open the corresponding .html help file.
Retrieve Current
I am trying to create a facility which returns all records where the date is equal to or greater to the current date. I currently have the following which returns all records:
I now need to do the following:
select * from shows where showDate >= today
Anyone know how I do this?
Get Current Page
I'm just working on this big newsletterscript, wich will be working with templates (preformatted html code), stored in the database. I've already started but i'm still looking for suggestions or methods to do this more easily then i'm up to right now. So when you you chose another design your content will be loaded in this other template/ html design.
Right now i'm having troubles with the fact that i have a page; nice formatted with the right content! Generated from asp visual output in pure html in my browser. What i want to do now is to get this page structure/ content as it is shown in my browers (html output) INSERTED into MS Access.
CURRENT DATE
I have an event that update my database, I would like to record the current date and time when the record was updated. Not quite sure of the command.
View Replies View RelatedAdd Hours To The Current Time
how you convert an integer such as 5 into an hour string so the system identifies it as an hour instead of just the number 5 and then once you do that ("if you need to do that at all") add 5 hours to the current time...
Also is there a way way to add lets say 50 hours to our current time and date so when it is calculated it shows 2 days and 2 hours away from now... If you cant do that it would be nice to know how to change 7.85 into just 7... or 8.94 into just 8... no rounding up or down just the first number before the decimal.
Ldap Asp Current User
how do i collect current user using ldap and asp, i want to know who's doing what, so when a page loads can i check who's logged in to the domain?
View Replies View RelatedFind Current Directory
I am wondering if there is a command to determine what the current directory is.
My reason for this is that i have a include file called connection.asp sat in a folder called Data. My connection.asp file holds the connection details. I need to determine whether the file calling the include is in the root folder or not.
EG. if it is the root folder the location of the db will be "Data/dbMarkShop.mdb" but if it is another folder, say a Scripts folder, the location of th db would be "../Data/dbMarkShop.mdb"
Finding Current Directory?
How can I find out the full directory path (i.e. c:path ofile) of a file? I'm logged into a server and the of course, I have an FTP directory root, but I need to know the absolute path.
View Replies View Related