how about you "export" the document anytime and only when it is updated, to a file that can be hit repeatedly until the next time it needs to be updated. then you just overwrite this "export" when the db is updated.
this way, if the document is only edited once or twice a...
here's a snippet of code i've used to do this:
note that myXmlOutputString should be valid xml.
Dim xmlResponse, htobj
Set htobj = Server.Createobject("MSXML2.ServerXMLHTTP")
htobj.Open "POST", "http://example.com/somepage.php", false
htobj.setRequestHeader...
hi guys! may i chime in with the following?
myFile.Writeline("<" & "% Response.Write text %" & ">")
this is similar when you want to write some javascript to another page using javascript, where where you might do the following:
document.write('<scr' + 'ipt> ...
sorry i missed it in your post noting between NT4 and 2K, and thought it was a CF vs. ASP question... yes, i'm using win2K, so hmmm maybe this is an NT4 issue?
highest regards,
-f!
to answer your second question, yes, you can run as many commands against a single connection as you want without having to open and close it each time. (beware however if working with transactions that an unchecked error in one statement might roll them all back.)
regards!
-f!
in addition to MrGreed's suggestion, i can think of two other ways off the top of my head to do this:
the first involves a "disconnected recordset" --- learn more at http://www.4guysfromrolla.com/webtech/080101-1.shtml or from google.
the second might be to delay executing your SQL...
i think you may want to investigate/troubleshoot your problem further; i use querystring values with no filename (i.e., the default page) and have no problems.
http://mydomain.com/somefolder/?foo=bar
works fine. can you elaborate on what you mean by the "redirect" page, and how you...
...exact suggestion to alter your SQL WHERE clause to use an IN statement instead of comparing equivalents.
This is perfectly valid SQL:
SELECT * FROM tablename WHERE shiftfield IN (1)
which is just as valid as
SELECT * FROM tablename WHERE shiftfield IN (2,3)
and
SELECT * FROM tablename WHERE...
would it work for you if you called your function on the results, after they've been returned from access, like so:
' get the data
strSql = "SELECT name FROM myTable"
Set rs = conn.Execute(strSql)
' display the results
Response.Write "value " & rs(0) & " is " &...
excellent! you are almost there! check my previous post in this thread, describing how to check/assign the anonymous user context to your IIS application, through the IIS management snapin. you will basically then rightclick the application, folder, or perhaps even the default website itself...
in windows explorer, try right-clicking on the folder/files in question, select properties, then go to security. in that dialog, you will want to add a user (named IUSR_MACHINENAME) and give that user full permissions. as your web pages are executed, they are done so under this IUSR user, so...
i have some experience with (but no affiliation with) a shopping cart package by Comersus (www.comersus.com) -- the "lite" version is open source, and free to use. it comes with an Access database and nice, thorough documentation. the developers of this software are friendly, and...
sorry if i wan't clear on this; the purpose of going into the computer management was to simply check to see under which user context your ASP pages are being executed (which in turn access the database), and not the other way around. you should not see the actual database file in your IIS...
if you are getting a NULL returned from your query, you could either just check for that special case, or instead tell SQL to return some value in place of the NULL by using the ISNULL() function,
SELECT ISNULL(Max(sort), 0) as maxsort
this would return 0 in place of a null, which would be the...
you were almost to the right place:
Computer Management --> Services and Applications --> Internet Information Services --> Web Site (either by name, or the default)
under this item, it will show you a list of the directories, virtual directories, and "applications" (i.e., just a...
if using a database (probably your best method) is out of the question, and you are not able to read/write to textfiles, consider using some dictionary objects that would, at the very least, be somewhat easier to troubleshoot and maintain over time...
Dim objLogins
Set objLogins =...
The account under which your IIS application runs, must have the proper permissions to access these files. Typically, your IIS applications will run under the IUSR_MACHINENAME account. The files/folders you are trying to access, must have their permissions explicitly set to allow this user...
perhaps verify that the application is truly running under the IUSR account? you can do this in the Computer Management console, under the IIS management snap-in. Verify the under "Authentication Methods" that the anonymous user for your Application has not been changed from its...
If you were familiar enough with VBA to write scripts, you will be pleased to hear that VBScript (default language of ASP) is very very similar! One minor difference will simply be in how your ASP page interacts with the database, but that is done through various ADO objects which you probably...
to work around IE's behaviour of wanting to warn/prompt the user that they are resubmitting form data, send them to another page just after you process the form that does not do any processing of its own, e.g.
page 1 is form that posts to page 2
page 2 processes form, but then sends user to page...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.