I have a form on my site that users must fill out before downloading a pdf document, however, i would like the form to send them an email with a temorary URL.
which they can click to download from, and which expires after 'x' days. is this an asp thing? or do i have to move to .net to do this?
I've got a web-based "database admin console" that uses ADOX, etc. to query a database and return the tables, columns, etc to a form that I can then use to build SQL statements to run against that database. It's very "generic" - i.e., everything is dymanically created but pretty handy to have
If you send it a "SELECT" statement, it can print out a table on the screen showing your recordset. No big deal. What I'd also like to include is some way for users to get that output in a comma- or tab-delimited text file that they can use however they like. There are two ways I know of to accomplish thi
1) Create a big string as I step through the recordset - (strOutput = strOutput & "'" & objRS(I) & "," .....) and then slap strOutput into a <textarea>. This is probably not desirable because the user would have to copy all the content in that <textarea> and manually paste it into Notepad or whatever
2) Use the FSO. However, my limited experience with the FSO leads me to believe that I'd have to SAVE the resultant file before I can send it to users. I don't want to do that.
Does anyone have any suggestions about how else I can accomplish this? Or, if FSO is the way to go (which I suspect it is), bear in mind that my only exposure to FSO is in the context of .vbs files....are there any special tricks you need to use for ASP
I keep getting this message onmy webiste. I have had to change from a DSN connection to a dsn less connection but i still can't get the site to work.
Link to the error message
Page
Here i sthe code that relates to the error message
Code:
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)};" & _
"DBQ=ftp://SimonJohnstone/htdocs/Tpvsite.mdb"
objConn.open
I need to take some info from a SQL Database into an ASP (VBscript) web page, create a temporary vcs file (Outlook vCalender file) and use the SQL data to create the entrys for the appointment, then email it to someone as an attachment. Getting the SQL values is no problem. How do I go about creating, populating & sending the vcs file? its similiar to a txt file. Its plain ASP not ASp.net and I can't install any components onto the server. It has to be kept local.
View Replies View RelatedIs there a way to create an asp program which counts the number of impressions, clicks, leads and sales of a certain ad and post it somewhere else? I have actually reviewed some ad servers one of which is Adxpress by Valuead. It's a good one but it'll really cost some money.
View Replies View RelatedI have a script that generates varius entities of data, like this
Name__________Value
nameA_________2
nameB_________18
nameC_________4
nameD_________23
I want to 'response.write' these onto the webpage, but I want them to be ordered by the value (largest first). Can I create a temporary table, put the values into it, then call them back using the an SQL command? If so, how do I create 'temporary tables'?
How I can erase all the files from the cache of an ASP page, at the end of a session?
Is it possible?
i am developing a search engine. its like this. i have an asp from which gets the search string. i display a page with a wait symbol for 2 seconds (meta-equiv-refresh=2) and then transfer the control to the same page which would display the search results.
I think even this forum does this type of display. Now my question is how do i start searching for the entered string and stop displaying the wait page only when the search is finished.
i.e i dnt want a wait page to be displayed simply for two seconds and then show the search page. I want to ""show the wait page after the search is started and then stop displaying it and display the search results only after the result is got""
I use the ASP to genereate the excel file. We use the Excel.Application to create a excel. But we find many excel shortcut or directory shortcut under the C: or D:
How can we resolve it?
Is it possible to delete internet temporary files using ASP code? And maybe specify the extension of the files to delete?
View Replies View RelatedWe have just signed up for salesforce.com and I need to somehow integrate the canned web-to-lead form from salesforce inside my login/registraiton system without messing up the existing 'join' form.My registration form is built on top of database while the alesform form isstatically generated form which is similiar but not exactly the same.
Post to two different urls at once for my main Join form.Or, perhaps 'hide' the salesforce.com form and somehow populate the values in the form and when the visitor clicks my Join form it also posts the sf form?
i have written a stored procedure. depending upon different parameters, query is prepared as string and executed through exec() function. it returns a certain number of rows. stored procedure also contains a temporary table. the question is this how can i insert the rows returned by the query in to temporary table?
View Replies View Relatedif it is possible to store the URL of a browser window as a variable? For example:
var loc = window.location.href
in JavaScript will store the contents of the address bar as the variable loc.
Is anyone aware of any sort of asp coding to deal with long URLs? I have a few asp that pull URLs from fields within a MS db, which then display on a width-limited table. Is there any way to wrap these long URLs such that my table doesn't get widened? e.g. wrapping at "/" or something similar?
View Replies View RelatedAre using this practice? If yes which method are you using?
View Replies View Relatedhas any one tried SE Friendly URLs with ASP & IIS? There's nothing like mod_rewrite for IIS. Ofcourse there are some 3rd party COM available but how many of us can use them on shared webservers?
So, is there a way to do it?
For those people who don't know what I'm talking about,
Normal URLs with querystrings look like
http://www.example.com/myPage.asp?id=1
while SE Friendly URL will look like
http://www.example.com/mPage/1/
The operative words being look like. You will see the 2nd URL in the browser's address bar but the server will take it as the 1st URL.
I need to convert the Query Strings into Clean URLs, Found some articles on
PHP and Apache server.. How do we it them with ASP ??
My application runs on ASP and the business logic is embedded in Dlls written in VB. The application hosts a list of articles for the user to view and these are accessible through some complex urls like "http://mysite/articles/category1?articleid=34512". I would like to denote a friendly url to these articles such as "http://mysite/articles/kb_TaxPlanning.asp". I am thinking of using an ISAPI filter to do the work for me. My friend was trying on using a httphandler, but it did not work. Please share with us the resources for creating an isapi filter for the same. Also how to use the same for the expected result?
View Replies View RelatedI have a dynamic table that displays names of companies. Some companies have URLs and some don't. I would like for those companies with URLs to open a new browser and show their website, for those with no URL just to open nothing. So far I have this, however doesn't work.
View Replies View RelatedIs there a way to add a header to a page that will change what text the
browser displays in the address field?
For example, say I point my browser to
http://www.domain.com/request.asp?a=1&b=2.
I would like IIS to send back the content generated by the page
request.asp, but would like the address is in the browser to read
"http://www.domain.com/request/index.asp"
Is there any possible way to do this? It seems like this should be possible.
I'd like to save images from urls ? I need to save images with a procedure that i get it the url of image. if anyone know about this problem, let me know?
View Replies View Relatedhow to create urls friendly in the term of 'search engine friendly'. I have a website writen in ASP. For example when i click to new page-About us, the url is ....
View Replies View RelatedAnyone know of a site that gives all of the syntax of relative addressing for URLS?
for example: /, ./, ../, etc.
Has anyone seen a good solution for Search Engine Safe URLs with Classic ASP? I've been looking for a while and short of using the 404 or installing tool on the server I was hoping there might be something else.In ColdFusion you can do a server.com/myfile.cfm/id/410 and it just works ... (well, after you parse the slashes)
View Replies View RelatedI having trouble with some of my classic asp pages being dropped from google.Specifically, a set of four pages reused many times with the content identified via query strings (max 3 variables). I was under the impression that google no longer has a problem with urls appended with query strings. Does anyone know if it is possible to incur penalties for the "over use" of such pages? My product detail page for example is used to display 230 seperate products.
if using static urls may help get my pages re-indexed, but I have had difficulty finding a way to do this with classic asp. Could anyone suggest a suitable method or advise possible reasons for my google disaster?
I am using ASP + IIS + MS access, when running the following codes:
set Conn=Server.CREATEOBJECT("ADODB.CONNECTION")
conn.open "DRIVER={Microsoft Access Driver
(*.mdb)}; " & Server.MapPath("db.mdb")
The following erorr is show:
General error Unable to open registry key
'Temporary (volatile) Jet DSN for process 0x508 Thread 0x634 DBC 0x2181024 Jet'.
I have shared the MS knowledge base and try to grant the modify Permissions to IUSR_SERVER on the folder that holding the database, and set the script authority in IIS, the error is still exist. If I create a system DNS for that Access file and modify the second code as ...
conn.Open "AKmobile"
Another error is show:
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
But there is no problem when conencting with MS SQL Server.
Why d I get this error?
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x18c8 Thread 0x1478 DBC 0x2f56fa4 Jet'.
/wheelofgod/search/cat/showbook.asp, line 102
I have this asp search engine that displays the urls for the files found, only the display shows %20. I need to remove the %20 and display a space instead; is there some way I can mask or remove that for displaying results for users?
View Replies View RelatedI am sending an email to subscibers of a news letter with the url of the latest newsletter in the email. this is built up in code. how do i encode it to include special characters such as spaces as %20. I have tried a simple replace routine but this gives errors on invalid chars.
View Replies View RelatedWhen someone buys something on my site from a detail page, I show them a cart. When they hit continue shopping, the only option I have right now is to take them back to the detail page. What I really would like to do is take them all the way back to the catalog page they used to get to the detail.
View Replies View RelatedI downloaded this simple function from 4Guys that uses RegEx to convert all URLs into hyperlinks. I need to alter it slightly so that the end of the link will be determined by a space (it does this now), or a "?", which ever comes first.
The problem is, I don't have a good grasp on RegEx patterns and I can't find how to do this. My pattern is below. Can someone tell me how to alter it to do this?
objRegExp.Pattern = "(www|http|S+@)S+"
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xa60 Thread 0xb30 DBC 0x1391ec4 Jet'.
/name.asp, line 17
my code:
All time that I go to make login to enter in admin is appearing this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x120c Thread 0x1494 DBC 0x1690024 Jet'.
/noticias/config.inc, line 6
In line 6 of config I have this: .....