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 SkipVought 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: PleaseGiveHelp
  • Order by date
  1. PleaseGiveHelp

    Syntax of query string using ASP

    If I have multiple forms on a page, do I need to somehow refer to which form I am using to yield the value of what is in the text box?
  2. PleaseGiveHelp

    Syntax of query string using ASP

    Though now in order to pass the variables, I think I have the syntax incorrect. It keeps asking for an object. This is what I have: <form name="SubmitMe" method="post" action="../../User_Info/processChanges.asp?user_id= <% =user %>&amp;password= <% =txtpassword.text %>&amp;user_id_1= <%...
  3. PleaseGiveHelp

    Syntax of query string using ASP

    Thanks you're right I had forgotten to pass the variables!
  4. PleaseGiveHelp

    Syntax of query string using ASP

    I am doing something wrong with my query string because I continuously get a message similar to: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ','. /User_Info/processChanges.asp, line 15 When I hit...
  5. PleaseGiveHelp

    Error: Command text was not set for the command object

    Never mind - I figured it out. Here is the correct syntax: <% Response.Redirect ("report.asp?strNo=" & strNo & "") %>
  6. PleaseGiveHelp

    Error: Command text was not set for the command object

    I think its the delete.asp page thats giving the problem because it can't read the string I'm feeding it: <% Response.Redirect ("report.asp?strNo='" & Response.Write("strNo") & "'") %>
  7. PleaseGiveHelp

    Error: Command text was not set for the command object

    I tried this and the sql is fine. Basically everything works until I change one thing. I am displaying the contents of the query along with a delete button. Once the button is pressed, the row is deleted. Behind the button is: Response.write "<a href='delete.asp?account_id=" &...
  8. PleaseGiveHelp

    Error: Command text was not set for the command object

    This is the code in the delete.asp page: <%@ Language=VBScript %> <% response.buffer="true" %> <!--#include file="../lib/voyager.inc"--> <% account = Replace(Trim(Request.QueryString("account_id")), "'", "''") cus = Replace(Trim(Request.QueryString("cusip")), "'", "''") trdate =...
  9. PleaseGiveHelp

    Error: Command text was not set for the command object

    I am receiving this error on my ASP pages: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E0C) Command text was not set for the command object. /admin/exceptions/voyg/report.asp, line 61 I only added one small thing so I don't understand why its freaking out on me. Any ideas?
  10. PleaseGiveHelp

    Response object error 'ASP 0156 : 80004005' HELP!

    Oh this worked. Thank you soooo much!!!!
  11. PleaseGiveHelp

    Response object error 'ASP 0156 : 80004005' HELP!

    I have an .asp page - when the user clicks the link to delete it brings them to yet another .asp page where at the end of the delete code I have a redirect statement. Yet it doesn't seem to be liked. This is the error I receive. Why? Response object error 'ASP 0156 : 80004005' Header Error...
  12. PleaseGiveHelp

    Error: Arguments are of the wrong type, are out of acceptable range

    I have a global.asa which provides the strings to pass and they're all there, so I don't get it: Application("conn1_ConnectionString") = "Provider=MSDASQL.1;Persist Security Info=False;User ID=Ident;Data Source=IDSrc;Initial Catalog=IDmark;User Id=IDent;PASSWORD=IDPass;UID=dbo;APP=Microsoft...
  13. PleaseGiveHelp

    Error: Arguments are of the wrong type, are out of acceptable range

    I am getting this error when I try to run my ASP page: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. /admin/tradeexecutions/lib/voyager.inc, line 26 So I go to this voyager.inc page, line 26 and here is the code: dim db ' Create and open...
  14. PleaseGiveHelp

    How can I extract a portion of a string

    This worked - thanks so much!!!!!
  15. PleaseGiveHelp

    How can I extract a portion of a string

    I am reading in a file name and I want to extract a piece of the file name. So if the filename is C:\Test\Test2\1234_Jingle[1].2_Done.csv, I only want the portion between the "-" and the "[". I believe I've done this within VB before but I cannot remember how. What function can I use to extract...
  16. PleaseGiveHelp

    .csv file in Excel HELP

    Never mind this does work if I put it after the first save and before the close. Thanks!
  17. PleaseGiveHelp

    .csv file in Excel HELP

    I'm still getting it. Should I send you all of my code? Perhaps I'm placing the code in the wrong area?
  18. PleaseGiveHelp

    .csv file in Excel HELP

    Nope still the same. I am still prompted to click on the No button...
  19. PleaseGiveHelp

    .csv file in Excel HELP

    This is what I have. Application.ActiveWorkbook.Save Application.ActiveWorkbook.Close This works for hte first save. But not for teh second...

Part and Inventory Search

Back
Top