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 derfloh 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: *

  1. DotNetDunce

    Storing a Sort Expression to a variable

    That's just what I was looking for! Thanks for the information, Jason! Learn something new everyday! Melinda
  2. DotNetDunce

    Storing a Sort Expression to a variable

    Thank you! I appreciate the help!
  3. DotNetDunce

    Storing a Sort Expression to a variable

    Thanks for the help! I need to hold the sort order so that a table inside a report displayed in a reportviewer control on the next page can mimic what is in the gridview of the previous page. How do I capture what is set in the gridview? I need to know how to grab it so I can pass it on. I...
  4. DotNetDunce

    Storing a Sort Expression to a variable

    Does anyone know how to save a sort order or sort expression to a variable after a user has sorted a gridview? When a user clicks a column and the gridview sorts I would like to capture that into a variable to pass to another page. Any help is appreciated!
  5. DotNetDunce

    Not All Variables Bound

    Thanks for your reply! Yes, the sql runs correctly outside of RS. I don't really understand why it is giving an error in RS, but I did manage to work around it by creating a function inside of Oracle to return the recordset. All is well now. Thank you for answering my post. Melinda
  6. DotNetDunce

    Not All Variables Bound

    Hi! I am a newbie to SSRS am using it to connect to an Oracle database. Until this point I've had no problems, but now I am setting up a dataset with a couple of subqueries and I am now getting this error: ORA-01008: not all variables bound. What do I need to do to get this to work? Here is my...
  7. DotNetDunce

    Visited Links

    Thank you for your replies. You have verified my information and hopefully this will help to convince my customer of my arguments. Thanks again!
  8. DotNetDunce

    Visited Links

    I think I already know the answer to this question, but a customer of mine seems not to be able to accept "No" as an answer so here goes. I have a website that is basically a bulletin board type site. As you are browsing the site the links to the posts change colors once they are visited. Is...
  9. DotNetDunce

    Type Mismatch error

    Thank you so much for that information. I had that idea in mind when I started, but wasn't sure exactly how to accomplish it. Thanks again!
  10. DotNetDunce

    Type Mismatch error

    I cannot believe I had that extra comma there and didn't see it and, yes, George (gmmastros), I would love a better way to do this. I just threw this together this morning to create a scheduled task and this was the first thing that came to mind. Thanks everyone for your help. Sometimes you...
  11. DotNetDunce

    Type Mismatch error

    ...sql2_abbs & "<br>" rs2.open, sql2_abbs, conn End Sub Conn.Open Set rs = Server.CreateObject("ADODB.Recordset") sql_abbs = "SELECT * FROM posts" rs.Open sql_abbs, conn cnt=0 cnt2=0 Do while not rs.eof 'response.write (DateDiff("m", Now, rs("date"))) if DateDiff("m", Now...
  12. DotNetDunce

    Windows Username/Password Prompt when opening a file

    Thanks for the suggestion! I checked that and there is nothing set there that asks for a password. As I mentioned before, if you click cancel on the prompt it goes away and then opens the file anyway. Judging from posts to other threads, could it be something in IIS? Any other suggestions...
  13. DotNetDunce

    Windows Username/Password Prompt when opening a file

    Hopefully, someone out there can give me an idea of where to look for this problem. I have a web site where the search option brings up a list of documents that meet the search criteria. If it is a text file or Word document it opens fine, but if it is a .xls file or a .ppt file, it throws up...
  14. DotNetDunce

    passing a parameter to Crystal Reports

    I'm apologize for not posting sooner. Here is the example I was given to figure it out. ReportDocument doc = new ReportDocument(); string fileName = Server.MapPath("ReportName.rpt"); doc.Load(fileName); doc.SetDatabaseLogon("login", "pass"); doc.SetParameterValue("param_name"...
  15. DotNetDunce

    passing a parameter to Crystal Reports

    Nevermind. I figured it out. :)
  16. DotNetDunce

    passing a parameter to Crystal Reports

    I have created a report using Crystal Reports in VS 2005 and everything works great on my local machine. There is a parameter field in the report and before the report is displayed, a prompt is displayed to collect the user data. When I run the application through the web server, all works fine...
  17. DotNetDunce

    GridView Sorting Problem (Repost)

    Thanks, jbenson001. I've been a member of this forum since 2001 and it seems like I've always been the one learning from scratch. I started out in ColdFusion, then went to ASP and some .NET, then to C++ and now I'm back to .NET and I've never got to stick with one long enough to become good at...
  18. DotNetDunce

    GridView Sorting Problem (Repost)

    This is a very small project and I am using Access for now. Eventually it will go over to SQL Server.
  19. DotNetDunce

    GridView Sorting Problem (Repost)

    Thank you!!! :)
  20. DotNetDunce

    GridView Sorting Problem (Repost)

    I've looked at this thing for so long I just didn't see it. Sometimes it takes a fresh pair of eyes to catch things. Thank you so much! I've never really posted anything to the forum because I'm too dumb, but I don't know what I'd without you guys! Works perfectly! Thanks a bunch!! Melinda

Part and Inventory Search

Back
Top