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!

Recent content by JonathanG6SWJ

  1. JonathanG6SWJ

    ASP - Upgraded from iASP 2.0 to Sun Java ASP 4.0.2

    Hi Guys My ISP has just performed an upgrade of ASP - Upgraded from iASP 2.0 to Sun Java ASP 4.0.2. Having at long last sussed the DB connection string I am now still unable to load my asp pages. Net result is that I am getting various error messages no doubt to do with slightly different...
  2. JonathanG6SWJ

    Connection String (HELP!)

    The actual upgrade was ASP - Upgraded from iASP 2.0 to Sun Java ASP 4.0.2 Jonathan
  3. JonathanG6SWJ

    Connection String (HELP!)

    Hi Guys I am very new to ASP and have been having great fun with the vertical learning curve and then my ISP moved the goal posts - I hope that my question is correctly posted to this forum. All had been going well until my ISP upgraded from iASP to Sun One (does that make sense!?) Since then...
  4. JonathanG6SWJ

    Error =SET OPTION SQL_BIG_SELECTS=1

    Hopefully that's a bit easier to read! SELECT tblCompetencyGroups.intCompetencyGroup_obj_no, tblCompetencyGroups.strCompetencyGroupText, tblCompetencies.intCompetency_obj_no, tblCompetencies.strCompetencyText, tblCompetencies.strAltFormatText, tblResultsData.intDelegate_obj_no...
  5. JonathanG6SWJ

    ASP/MySql error (SET OPTION SQL_BIG_SELECTS=1)

    Having now done more research I think I'm just demanding too much from mysql. Does any body know how to use SET OPTION SQL_BIG_SELECTS=1 from within ASP Jonathan
  6. JonathanG6SWJ

    Error =SET OPTION SQL_BIG_SELECTS=1

    Here I was putting the finishing touches to my first, quite complex (well for me anyway) asp/db application and then I add a few more test records to my db.... the result the following error message... CODE Vbscript Runtime error 'ASP 0185 : 3219' General error: The SELECT would examine too...
  7. JonathanG6SWJ

    ASP/MySql error (SET OPTION SQL_BIG_SELECTS=1)

    An Update If I remove the ORDER BY tblCompetencies.intCompetency_obj_no the query works! Is this Select statement just too much for MySql? Jonathan
  8. JonathanG6SWJ

    ASP/MySql error (SET OPTION SQL_BIG_SELECTS=1)

    Hi There Here's the statement sSQL="SELECT tblCompetencyGroups.intCompetencyGroup_obj_no," sSQL=sSQL+" tblCompetencyGroups.strCompetencyGroupText," sSQL=sSQL+" tblCompetencies.intCompetency_obj_no," sSQL=sSQL+" tblCompetencies.strCompetencyText," sSQL=sSQL+"...
  9. JonathanG6SWJ

    ASP/MySql error (SET OPTION SQL_BIG_SELECTS=1)

    Here I was putting the finishing touches to my first, quite complex (well for me anyway) asp/db application and then I add a few more test records to my db.... the result the following error message... Vbscript Runtime error 'ASP 0185 : 3219' General error: The SELECT would examine too many...
  10. JonathanG6SWJ

    Displaying text from mySql DB

    Hi Tony Answer to 2nd question was - it's just a string one two three - no line breaks or other control characters lurking! Your first question prompted me to recreate the table & data in Access, delete mySql table and export new access table to mySql. I've done that and it works all OK. So I...
  11. JonathanG6SWJ

    Displaying text from mySql DB

    Hi Tony The working text was exported from an MS Access table. The text that does not work was typed straight into table using MySQL Control Center. Jonathan
  12. JonathanG6SWJ

    Displaying text from mySql DB

    I am having trouble displaying text from a mySql DB. I have a field in a DB of type "medium text". I sucessfully diplay these on my asp page asigning them to a variable altText=RS("dbfield") and then outputting using response.write. All works ok. I have another field of "medium text" and use...
  13. JonathanG6SWJ

    How to set "selected" in list box?

    Thanks Tony Really appreciate that.. Jonathan
  14. JonathanG6SWJ

    How to set "selected" in list box?

    Thanks Tony. Is there an obvious way I can do this programatically (is that a word!) In other words dynamically build the list box and define which one is selected depending on details from a record from a DB. Jonathan
  15. JonathanG6SWJ

    How to set "selected" in list box?

    On an asp page that allows the user to edit account details I have a list box showing relationships. I need to set the selected option to that retrieved from a DB record when I create / present the edit page to the user. No matter what I try I always seem to select the last item in the list -...
See more

Part and Inventory Search

Back
Top