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

    Three Tables and a Group By

    Woo Hoo, Thanks Rick! I was getting confused with the crud names I'd given the tables and fields. I renamed them and rewrote the query with your suggestions and it works a treat! SELECT Count(*) AS NumberOfQuestions, Category.CategoryName, QuestionTypes.QuestionTypeName FROM QuestionTypes...
  2. BatGrrrL

    Three Tables and a Group By

    Thanks Rick, I changed the typo in the code (I had cut and pasted it), made the joins inner types and added the count(*) and it's closer to working. When I run the query, it pops up a box asking for the qcat and the qtypeid. So I type in 1 and 1 and it returns one line with the two numbers I...
  3. BatGrrrL

    Three Tables and a Group By

    Hi Guys, I need some help with a couple of tables and a query. I am building a test generator for our teachers here (we are a school) and I have set up my tables as follows: QCat: QCatID - PK QCat QTypes: (Question Types eg, True/False, Multi Choice) QTypeID - PK QType Questions: QID - PK...
  4. BatGrrrL

    Checking if something is in focus

    Solved it: I load currentFocus = '' at startup. when they focus on my iframe i set currentFocus = 'iFrame' when they click outisde that it goes back to currentFocus = '' Yay :)
  5. BatGrrrL

    noob question- popdown image change

    And this is the code to do it with a drop down box :) Note: the three images I used were in the same directory as my script. <html><head> <script language=&quot;javascript&quot; type=&quot;text/javascript&quot;> <!-- function image_go() { selecteditem = myForm.myImages.selectedIndex ...
  6. BatGrrrL

    noob question- popdown image change

    Hi Zas, You could try something simple like this: Have your thumbnails as <img> with a A HREF around them: <a href=&quot;#&quot; onClick=&quot;card.src='/images/ecards/BigImage.jpg';&quot;> And your main image called &quot;card&quot; (in this example) <img...
  7. BatGrrrL

    Checking if something is in focus

    Hi Guys, Could someone please tell me how I can tell if my iframe is in focus? I'm writing a wysiwyg editor using the execcommand in javascript and ie and if the focus is outside of the iframe (on the main page body) then my buttons will write their output to the main page rather than the...
  8. BatGrrrL

    newbie - passing arguments

    <SCRIPT LANGUAGE = &quot;JavaScript&quot;> function ConFirm(x) { if (confirm(&quot;Do you want to delete this?&quot;)) { window.open(x,&quot;_self&quot;); } } </script> <a href=&quot;#&quot; onmousedown=javascript:ConFirm(TODO.php);&quot;> <img src=&quot;gfx/checked.gif&quot...
  9. BatGrrrL

    Help with a Selects onSelect

    Ohh Solved: <script language=&quot;JavaScript&quot;> <!-- function popRef(BillerID) { var BID; BID = BillerID.options[BillerID.options.selectedIndex].value; var Brow; Brow = eval(&quot;document.addBill.BR&quot; + BID + &quot;.value&quot;); document.addBill.BillerRef.value = Brow...
  10. BatGrrrL

    Help with a Selects onSelect

    Hi, Can someone please tell me where I'm going wrong here. I'm making my own bill payment system in asp. A Select box is filled with the Names of the Billers. <option value=&quot;<%= rs( &quot;BillerID&quot; ) %>&quot;><%= rs( &quot;BillerName&quot; ) %></option> And hidden field is assigned...
  11. BatGrrrL

    Error code 3021 When no records Found..

    Thanks Zemp, I know alot about ADO in ASP so that would be a good start! Thanks for the tips :) BatGrrrL :)
  12. BatGrrrL

    Error code 3021 When no records Found..

    Hi Guys, Have been handed a working project and have very little understanding of how it works (Im an asp web person) Can someone please help me with the following. When a user searches for a Surname in this program, if the Surname is not found it returns an error of: &quot;Run-time error...

Part and Inventory Search

Back
Top