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...
you could make the dropbox a multiple-selection listbox, such as:
<select size="3" name="Shift" multiple="multiple">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
</select>
<p>(Hold down...
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...
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.