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 TouchToneTommy 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: gtubb
  • Order by date
  1. gtubb

    Passing a string URL into javascript

    Many thanks - it works! This might seem a dumb question, but why does js remove the slashes in the first place?
  2. gtubb

    Passing a string URL into javascript

    Hi folks I can handle ASP, but I'm a bit of a novice at Javascript. I have a working javascript slide show function. I want to pass a URL from a hidden form field into the script like so: Pic[1] = '<%=request.form("picture2")%>' This puts the URL of the picture into the script, but strips...
  3. gtubb

    jmail returns a comma instead of contents of memo field

    Hi folks I'm new to jmail - I can get it to return the contents of fields from an access database - but not from a memo field. All it returns is a comma. I've Googled for ideas, but got nowhere. Any ideas? Thanks Gerard
  4. gtubb

    why won't form send hidden value?

    I cut and pasted the code from a script that used AspUpload - and forgot to delete the enctype. Thank you for your help Gerard
  5. gtubb

    why won't form send hidden value?

    Hi folks I have a simple form with a hidden value: <form method="POST" enctype="multipart/form-data" action="edit_comment.asp" name=submitform> input type=hidden name="email" value="wrg"> input type=SUBMIT name="submit" value="Edit the message"> But for some reason the value is not being...
  6. gtubb

    script hanging with ID number

    Thank you both. if cInt(rs(&quot;ID&quot;)) = Cint(Request.QueryString(&quot;folder&quot;)) then did the trick
  7. gtubb

    script hanging with ID number

    Tarwyn Forgive my beginners limitations, but where do I try cStr() or cInt() in the script?
  8. gtubb

    script hanging with ID number

    BDC Thanks - I hadn't noticed that I'd moved it - the script has been changed so many times trying to make it work. Now it doesn't hang, but with a numeric value passed in the URL (blah.asp?ID=46)it won't delete the file. response.write Request.QueryString(&quot;folder&quot;) &...
  9. gtubb

    script hanging with ID number

    Hi The following script works fine if the variable passed the the URL is text. If I make the variable a number (ID) then the script hangs with no error message. I've tried removing the & &quot;'&quot; but it makes no difference. Can anyone help? sql_fields = &quot;SELECT * FROM categories...
  10. gtubb

    unterminated string constant

    Davejam Tried that and it didn't work. It was the most obvious thing: I'd cut a pasted the code from the graphical query tool - which had introduced line breaks into the code. My stupid fault. Gerard
  11. gtubb

    unterminated string constant

    Hi I have constructed the following SQL statement using the graphical query tool in Access (the query works fine). sql_fields =&quot;SELECT categories.category_name AS categories_category_name, Count(items.category_name) AS items_category_name FROM items INNER JOIN categories ON...
  12. gtubb

    what's wrong with this script - trying to call a function

    Foxbox, you're a star. The full script for anyone who wants to create a backup (in this case of a database)to a separate folder, date it and number each version sequentially is as follows: <% dim backedfile Set fso = CreateObject(&quot;Scripting.FileSystemObject&quot;) 'change the following to...
  13. gtubb

    what's wrong with this script - trying to call a function

    I've adapted the function to write the correct version of the backup (if the response.write comes after the fso.copyfile it writes the current file plus one increment) I can't work out what variable to put in the brackets after if fso.FileExists to make the script report &quot;file backed...
  14. gtubb

    what's wrong with this script - trying to call a function

    Forgive my ignorance, but how does the script pick up the source file?
  15. gtubb

    what's wrong with this script - trying to call a function

    Sorry - it's been a long day of progamming :) Set fso = CreateObject(&quot;Scripting.FileSystemObject&quot;) sDate = Date sDate = Replace(sDate, &quot;/&quot;, &quot;&quot;) sourceFile = &quot;c:\upload\test.html&quot; destFile = &quot;c:\upload\backup\backup_&quot;& sDate &&quot;.html&quot...
  16. gtubb

    what's wrong with this script - trying to call a function

    Hi folks The following script copies a file to a backup folder, and dates it by renaming it 'backup30012004' - the digits are today's date, minus the '/'s It works until I try to call the function checkdup(filename) which is supposed to add an extra digit on the end of the name of the backed...
  17. gtubb

    how can make an INSERT INTO statement see a variable?

    Thank you. When this site is finished I'll owe you several beers.
  18. gtubb

    how can make an INSERT INTO statement see a variable?

    Hi Can anyone tell me how I can get a table name passed in the URL (page.asp?=blah)to work with the INSERT INTO code below? My attempts with dim strTblename strTblename = Request.Querystring(&quot;Table&quot;) SQL = &quot;INSERT INTO strTblename just returns the error message &quot;Could not...
  19. gtubb

    Can you adapt this script so user can create their own table &amp; name?

    I've solved it! Thanks Foxbox. The form works with the following script: (now all I have to do is work out how to check for existing tables of the same name): <%@ Language=VBScript %> <% Set conn = server.CreateObject(&quot;ADODB.Connection&quot;) connectstring = &quot;Driver={Microsoft Access...
  20. gtubb

    Can you adapt this script so user can create their own table &amp; name?

    Thank you for your help. You're going to think this question is really stupid, but I'm new to this. How do I get your code (which returns &quot;CREATE TABLE ..... (Name text (50), Email text (75), Comments text (255), Region text (50))&quot;) to create the table? Sorry to be so thick...

Part and Inventory Search

Back
Top