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

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

    syntax prob- retrieve & submit value from function

    Hi Guys. I've played with the syntax below so much I've forgotten what I've tried and what I haven't. So I thank you in advance for keeping me sane. I am trying to retrieve the index value for the option box. Here's the function <script type="text/javascript"> function getIndex() { var...
  17. JonathanG6SWJ

    = operator producing strange results

    Hi Guys This has to be something so incredibly simple, I'm sure I'm going to be embarrassed by the answer. if intpage =9 then Response.Write "Confirmed intpage= 9 " End If >>>>>Result true Response.Write outputs text if intpagecount =9 then Response.Write"intPageCountpage= 9" End If...
  18. JonathanG6SWJ

    Where did the COMMA come from!

    I guess its obvious when you know and quite logical! Another little gem to remember. Thanks Tony
  19. JonathanG6SWJ

    Where did the COMMA come from!

    Hi I have an asp page with a submit button <input type="submit" name="btnSelection" value="I made this choice"> On another page I Request.Form("btnSelection") and get the result I made this choice , Where / why have I got a space and a comma appended to the end of the text after the word...
  20. JonathanG6SWJ

    Conditional submit

    Wow.. I was typing my response only to find more replies in the mean time... I think I've lost the plot.. It would appear that session variables may well be the way to go but would I be correct in saying they are stored as a cookies.. if so my users will more than likely have cookies disabled.... J

Part and Inventory Search

Back
Top