Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Funka

  1. Funka

    ASP Processing from DB

    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...
  2. Funka

    How to make Web request from asp

    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...
  3. Funka

    Creating Strings of ASP Code

    hi guys! may i chime in with the following? myFile.Writeline(&quot;<&quot; & &quot;% Response.Write text %&quot; & &quot;>&quot;) 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> ...
  4. Funka

    QueryString fails on default page

    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!
  5. Funka

    Stored Procedure error

    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!
  6. Funka

    Batch execute Recordset

    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 &quot;disconnected recordset&quot; --- learn more at http://www.4guysfromrolla.com/webtech/080101-1.shtml or from google. the second might be to delay executing your SQL...
  7. Funka

    QueryString fails on default page

    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 &quot;redirect&quot; page, and how you...
  8. Funka

    Multiple Values in an ASP query selection

    you could make the dropbox a multiple-selection listbox, such as: <select size=&quot;3&quot; name=&quot;Shift&quot; multiple=&quot;multiple&quot;> <option value=&quot;1&quot;>1</option> <option value=&quot;2&quot;>2</option> <option value=&quot;3&quot;>3</option> </select> <p>(Hold down...
  9. Funka

    Is it possible to execute VBA code from external app via ADO like ASP?

    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 = &quot;SELECT name FROM myTable&quot; Set rs = conn.Execute(strSql) ' display the results Response.Write &quot;value &quot; & rs(0) & &quot; is &quot; &...
  10. Funka

    ASP Connection to Access Database – Security Questions

    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...
  11. Funka

    ASP/VB write error

    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...
  12. Funka

    shopping cart

    i have some experience with (but no affiliation with) a shopping cart package by Comersus (www.comersus.com) -- the &quot;lite&quot; 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...
  13. Funka

    ASP Connection to Access Database – Security Questions

    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...
  14. Funka

    Adding a Null

    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...
  15. Funka

    ASP Connection to Access Database – Security Questions

    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 &quot;applications&quot; (i.e., just a...

Part and Inventory Search

Back
Top