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!

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

Search results for query: *

  • Users: Funka
  • Order by date
  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

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

    If request.form = blah blah... else.. statements slow down, speed help

    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 =...
  17. Funka

    ASP/VB write error

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

    ASP Connection to Access Database – Security Questions

    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 &quot;Authentication Methods&quot; that the anonymous user for your Application has not been changed from its...
  19. Funka

    Should I use ASP or some other technique?

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

    Destroy form data

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

Part and Inventory Search

Back
Top