Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Hi, I've already created a report which uses snaked (column) formatting with gives 7 columns for a months worth of data. I'm having trouble formatting the report so that it appears like a calendar... i.e so that the first day is a monday (or possibly a sunday?) At present the first day appears...