Search results for query: *

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

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

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

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

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

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

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

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+"...

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

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

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

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

Thanks Tony Really appreciate that.. Jonathan

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

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

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

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

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

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

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