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 grobermatica

  1. grobermatica

    Combo Box / URL Variable / Update Form

    Hi everyone, I've been referred over to this forum re my question in the PHP forum about my update form where i'm trying to populate a combo box dynamically. I'm having problems however as the URL is set via javascript and I cant get it to set the correct ID in the URL. A user in the PHP forum...
  2. grobermatica

    Cobmo Box / URL Variable / Update Form

    HI Phil, Thanks for replying, I apologise if I was not clear what I was trying to achieve. The form is generated by the Adobe Dreamweaver Developer Toolbox as is the javascript function which updates the URL, which is: function MM_jumpMenu(targ,selObj,restore,salon){ //v3.0...
  3. grobermatica

    Cobmo Box / URL Variable / Update Form

    I have a form which updates records, some of the field in the update form are combo boxes and the second one is dynamically dependant on the first one. I have another combo box at the top of the form in which you select the record you want to edit. This populates a url variable which is the...
  4. grobermatica

    Dependant Drop Down Menu PHP/MySql

    So are we saying that its not possible to do what I want? Not sure what you mean by a cartesian product? I'm guessing a plain HTML would mean no database link?... if so not an option. If javascript is the way to go does anyone have any example code? Cheers Craig
  5. grobermatica

    Dependant Drop Down Menu PHP/MySql

    Hey, I've got 2 dependant drop down menus (jump menus) on a php page the first I added and it works fine... adding a URL extension (?show=16) via the javascript mm_jumpmenu function. However I now want to add another drop down menu to filter the results even further using a selection of dates...
  6. grobermatica

    Dynamic Query Between 2 Dates (Text Box Refs)

    Hi, I'm trying to query a list between 2 dates which have been entered on an underlying form ("frmBetweenDates"... I've done this before and I think its pretty simple but can't remember how to do it... I just keep getting an empty result. The criteria I have entered is as follows: Between...
  7. grobermatica

    SQL LIMIT Conflict in Dreamweaver MX ??

    Thanks vacunita... I'll give it a try :0) Craig
  8. grobermatica

    SQL LIMIT Conflict in Dreamweaver MX ??

    I thought so too but if I tweak it in this way to remove the LIMIT part... I get more errors... its like dreamweaver expects it to be there and if I remove it or change the "%d" to my own values dreamweaver ain't happy. Can't post the error at the moment as I'm an a different machine but I'll...
  9. grobermatica

    SQL LIMIT Conflict in Dreamweaver MX ??

    The wierd thing is that the error reports the syntax LIMIT 0,5 which is not what I have entered... this makes me think that Dreamweaver is passing this LIMIT. There are the following lines in the code generated by dreamweaver: mysql_select_db($database_stdConnx, $stdConnx); $query_rstNewsList...
  10. grobermatica

    SQL LIMIT Conflict in Dreamweaver MX ??

    Hi, the query is a simple one: SELECT * FROM tblnewsitems ORDER BY dteAdded DESC LIMIT 1,999 I'm pretty sure that the LIMIT part is the cause because when I take it out all is fine... except that I get the top record in with the rest... which is what I'm trying to avoid as it is displayed...
  11. grobermatica

    SQL LIMIT Conflict in Dreamweaver MX ??

    Hi, I'm using Dreamweaver to create a list from a MySQL table, however I want to limit the list using the SQL syntax "1,999" (so that I can start at the second record and go from there.) However when I load the page on the server I get an error: You have an error in your SQL syntax; check the...
  12. grobermatica

    SQL LIMIT Conflict In DMX

    Hi, I'm using Dreamweaver to create a list from a MySQL table, however I want to limit the list using the SQL syntax "1,999" (so that I can start at the second record and go from there.) However when I load the page on the server I get an error: You have an error in your SQL syntax; check the...
  13. grobermatica

    How Do I Create A Calendar Report

    I've sorted it... for anyone who's interested here's the code I used... its a bit messy but I'm no pro: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Dim intDay As Integer Dim intDayValue As Integer intDay = Format(Me.ConstDate, "d") If intDay = 1 Then Select...
  14. grobermatica

    How Do I Create A Calendar Report

    So are you saying that I need to query the whole year and narrow the results down using code? Isn't there a way to do it by only querying the month, then change where the results start using code? Cheers Craig
  15. grobermatica

    How Do I Create A Calendar Report

    Hi dhookom, Thanks for your reply... I had actually already seen this and the reports in the sample databse don't do what I want. I'm looking for a report which shows the whole month... the sort you would see in a calendar that you would buy that has 1 page for each month... I'll attempt an...
See more

Part and Inventory Search

Back
Top