Both sites are on the same server. ... View more

I have CS6 but have not made the change yet. The strange thing is that I have another site which has the identical code.  It works just fine.  This might mean the issue is somewhere else but is affecting the lines referenced above. Any suggestions for proceeding? ... View more

First I only changed mysql_select to mysqli_select .  This does not result in any change. Then I changed every instance of mysql to mysqli . In each case the result is unchanged.  In other words: This does not result in either case does not fix the issue. Warning: mysql_select_db() expects parameter 2 to be resource, null given in /home/ibtib/public_html/chsn/login2.phpon line 19 Warning: mysql_query() expects parameter 2 to be resource, null given in /home/ibtib/public_html/chsn/login2.php on line 24 Also, when I make the change in the code itself, adding the "i" to mysql = mysqli, the code changes from red to black, which probably means it is no longer active -- my hunch, only. ... View more

Hi Ned, I'm pretty sure I installed DW CS6 before, but it must have disappeared somehow. Nevertheless, I was able to restore it from the full CS6 Master Collection package. All is OK! Thanks for helping, Curt ... View more

2. Re: I own Master Collection CS6 since a little over a years ago, and am slowy upgrading from older versions of the programs.  Still using DW MX 2004, but now need to set up DW CS6.  Looking at my downloaded packages I don't see DW CS6 anywhere.  Grateful curtgus Apr 30, 2015 2:46 PM (in response to Curt Gustafsson) Installed on Windows 7 Pro I have: AE (*) AA BR64 BR EN Adobe Extend      Toolkit      Extension Manager FW (*) FL AI AI64 ID (*) Adobe Media Encoder PS PS-64 (*) PL PR SG (*)   I am currently using these on regular basis. In the Download Directory I have: Illustrator_16_Content_LS16.exe InDesignFamily_8_Content_ALL.exe MasterCollection_CS6_LS16.7z MasterCollection_CS6_LS16.exe PremierePro_6_Content_LS7.7z PremierePro_6_Content_LS7.exe Maybe DW CS6 64 is in one of these Downloaded files? /Curt ... View more

Installed on Windows 7 Pro I have: AE (*) AA BR64 BR EN Adobe Extend      Toolkit      Extension Manager FW (*) FL AI AI64 ID (*) Adobe Media Encoder PS (*) PS64 PL PR SG (*)   I am currently using these on regular basis. In the Download Directory I have: Illustrator_16_Content_LS16.exe InDesignFamily_8_Content_ALL.exe MasterCollection_CS6_LS16.7z MasterCollection_CS6_LS16.exe PremierePro_6_Content_LS7.7z PremierePro_6_Content_LS7.exe Maybe DW CS6 64 is in one of these Downloaded files? /Curt ... View more

Hi Micha. Thank you for your reply. It seems your suggestion has some possibilities. I have attached (in order to preserve some formatting of the text) my further explanations and questions, but I am not sure how well this works in this Adobe forum system. If you are able to respond also to this, it will be very much appreciated. Sincerely, Curt L. Gustafsson ... View more

quote: Originally posted by: Newsgroup User Try after you create your recordset, drag you field to the design surface, arrange as desired. Highlite group and apply repeated region. It works, you may just have to work at it a little while. Once you get it it is very quick. ------------------------ Hi, and thank you for your reply. However, the "Repeated Region" Server Behavior cannot be nested. In other words, "Repeated Region" cannot be used to categorize data output. "Repeated Region" only outputs all data for each record -- each row contains all fields for each record (specified in the query and dragged to the output page), in other words, as seen here: http://www.sala.pingst.se/htm/sp_kalender_view.php Once again, data on the output page needs to be categorized, and subcategorized as follows: v. 19 Servicegrupp Elisabet Hedman (main category) Tisdag 17 april 13:00 Bön 17:00 Äldstemöte 19:00 Ungdomsmöte Onsdag 18 april 19:00 Körövning Torsdag 19 april etc. v. 20 Servicegrupp Alsiö/Andersson (another main category) etc Perhaps I'm not fully understanding the "Repeated Region" Server Behavior, but it does appear that it cannot be used to accomplish what needs to be accomplished in this case. Further help is needed on this. Sincerely, Curt L. Gustafsson ... View more

Yes, Hooray! David said: > The problem with the Dreamweaver code is that it doesn't make it easy to write custom SQL queries like this, so you need to understand the code to be able to customize it. Yes, this is what I was stuck on! I figured the problem would be in the INSERT area, but how to pass the value was a mystery. Now as for the output, it currently looks like this: http://www.sala.pingst.se/htm/pr/sp_kalender_view.php There are two goupings that need to be implemented. 1) the "v. ## Servicegrupp Xxxxxx Xxxxxxxxx" should be then main group, with all the dates for that week sorted under this heading, and 2) within each main group, the activities for identical dates should be grouped together and ordered by time -- when there is more than one event for a given date, the date should only appear above the first event in that group. Example: v. 19 Servicegrupp Elisabet Hedman Tisdag 17 april 13:00 Bön 17:00 Äldstemöte 19:00 Ungdomsmöte Onsdag 18 april 19:00 Körövning Torsdag 19 april etc. v. 20 Servicegrupp Alsiö/Andersson etc. I have experimented with "Region" in DW but this does not seem to offer a solution -- there are limitations. I have also searched for code to accomplish this, but have not found anything helpful yet. Best would be if it can be done within Dreamweaver, of course. Once this webpage grouping is solved, the next task is to commit this data to paper where it must "snake" over three columns on a landscape format page. But that's another story! Maybe you have some helpful suggestions on the grouping problem. This will be much appreciated. (By the way, I can do it in Access, but I'm stuck in DW, and PHP/MySQL.) Sincerely, Curt L. Gustafsson ... View more

David, Thanks for this: ----------------- Change the section above to this: $insertSQL = sprintf("INSERT INTO kalendar (datBegin, week_nbr, tid, mote, kommentar) VALUES (%s, DATE_FORMAT(%s,'%%u'), %s, %s, %s)", GetSQLValueString($_POST['datBegin'], "date"), GetSQLValueString($_POST['datBegin'], "date"), GetSQLValueString($_POST['tid'], "date"), GetSQLValueString($_POST['mote'], "text"), GetSQLValueString($_POST['kommentar'], "text")); ----------------------- It works!! If your help site had grades and points, like Experts Exchange does, I'd give you an A+ and 500 points (the max)! Very much appreciated. Thank you. And thank you especially for the explanation of why it works. This is very helpful, because I'm sure the problem will come up again. I have two other questions regarding grouping the output of this data, but I'll post those later. Sincerely, Curt L. Gustafsson ... View more

Repeated to ensure delivery David, Thanks for checking this out, and for finding the same problem as I found. re. INSERT INTO kalendar (datBegin, week_nbr) VALUES ('beginningDate', DATE_FORMAT('beginningDate', '%u')) I looked at this as well, earlier, and this probably works. But, since I'm working in Dreamweaver MX (2004), I don't know where to put it. I tried to put it in Values for a Hidden Field. First of all, that accepts only one line of code, but the syntax also does not fit there, seemingly. Then I tried to find a way to put this into the INSERT sction in the code itself. There, I couldn't figure out how to enter the values. Here is where I'm at on that: $editFormAction = $_SERVER['PHP_SELF']; if (isset($_SERVER['QUERY_STRING'])) { $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']); } if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form2")) { $insertSQL = sprintf("INSERT INTO kalendar (datBegin, week_nbr, tid, mote, kommentar) VALUES (%s, %s, %s, %s, %s)", GetSQLValueString($_POST['datBegin'], "date"), GetSQLValueString($_POST['week_nbr'], "date"), GetSQLValueString($_POST['tid'], "date"), GetSQLValueString($_POST['mote'], "text"), GetSQLValueString($_POST['kommentar'], "text")); mysql_select_db($database_Sala_Pingst, $Sala_Pingst); $Result1 = mysql_query($insertSQL, $Sala_Pingst) or die(mysql_error()); } ?> <?php require_once('../../Connections/Sala_Pingst.php'); ?> <?php mysql_select_db($database_Sala_Pingst, $Sala_Pingst); $query_Recordset1 = "SELECT kalendar.id, kalendar.datBegin, kalendar.tid, kalendar.mote, kalendar.kommentar, servicegrupp.id, servicegrupp.name, servicegrupp.vecka FROM kalendar, namn, servicegrupp "; $Recordset1 = mysql_query($query_Recordset1, $Sala_Pingst) or die(mysql_error()); $row_Recordset1 = mysql_fetch_assoc($Recordset1); $totalRows_Recordset1 = mysql_num_rows($Recordset1); If you could just advise me on where to put: INSERT INTO kalendar (datBegin, week_nbr) VALUES ('beginningDate', DATE_FORMAT('beginningDate', '%u')) the problem is likely going to be solved. Thanks and greetings, Curt Text ... View more

David, Just a quick comment on: > WHERE kalendar.week_nbr = servicegrupp.vecka > Without experimenting with your actual data, it's hard to work out why this doesn't work. However, you should be able to insert the week number like this Logically, the data on which the query acts comes from the database. In our case, now, we need to direct the data TO the database BEFORE the query can act on it. It's a matter of timing, in other words. INSERT has to happen before SELECT can take place. Nothing profound about that. Curt ... View more

David, Thanks for checking this out, and for finding the same problem as I found. re. INSERT INTO kalendar (datBegin, week_nbr) VALUES ('beginningDate', DATE_FORMAT('beginningDate', '%u')) I looked at this as well, earlier, and this probably works. But, since I'm working in Dreamweaver MX (2004), I don't know where to put it. I tried to put it in Values for a Hidden Field. First of all, that accepts only one line of code, but the syntax also does not fit there, seemingly. Then I tried to find a way to put this into the INSERT sction in the code itself. There, I couldn't figure out how to enter the values. Here is where I'm at on that: $editFormAction = $_SERVER['PHP_SELF']; if (isset($_SERVER['QUERY_STRING'])) { $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']); } if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form2")) { $insertSQL = sprintf("INSERT INTO kalendar (datBegin, week_nbr, tid, mote, kommentar) VALUES (%s, %s, %s, %s, %s)", GetSQLValueString($_POST['datBegin'], "date"), GetSQLValueString($_POST['week_nbr'], "date"), GetSQLValueString($_POST['tid'], "date"), GetSQLValueString($_POST['mote'], "text"), GetSQLValueString($_POST['kommentar'], "text")); mysql_select_db($database_Sala_Pingst, $Sala_Pingst); $Result1 = mysql_query($insertSQL, $Sala_Pingst) or die(mysql_error()); } ?> <?php require_once('../../Connections/Sala_Pingst.php'); ?> <?php mysql_select_db($database_Sala_Pingst, $Sala_Pingst); $query_Recordset1 = "SELECT kalendar.id, kalendar.datBegin, kalendar.tid, kalendar.mote, kalendar.kommentar, servicegrupp.id, servicegrupp.name, servicegrupp.vecka FROM kalendar, namn, servicegrupp "; $Recordset1 = mysql_query($query_Recordset1, $Sala_Pingst) or die(mysql_error()); $row_Recordset1 = mysql_fetch_assoc($Recordset1); $totalRows_Recordset1 = mysql_num_rows($Recordset1); If you could just advise me on where to put: INSERT INTO kalendar (datBegin, week_nbr) VALUES ('beginningDate', DATE_FORMAT('beginningDate', '%u')) the problem is likely going to be solved. Thanks and greetings, Curt ... View more

Hi David Powers, Thanks for your input regarding the week number problem. re. > The way to do it is to use DATE_FORMAT(datBegin,'%u') as part of your query. For example: SELECT thisCol, thatCol, DATE_FORMAT(datBegin,'%u') as week_num FROM mytable ORDER BY week_num DESC This is exactly what I have tried over and over again, many times. This approach fails when you add the WHERE statement: WHERE kalendar.week_nbr = servicegrupp.vecka However, when I hard code the week_nbr into the kalendar table, then the WHERE statement works as intended. There is a match, in other words. It appears that the reason it does not work unless the week_nbr is in the table, is that "week_num" (as you have it) from the query is not a field but something else, perhaps a variable. I'm not sure about the terminology. To match output from the table with output from an AS statement in the query does not work -- at least not in my experience. I guess the scenario is one of relations. In other words the "week_nbr" from the kalendar table relates to the "vecka" in the servicegrupp table. When both are present in their respective tables, the match occurs. To try to match them at the output stage, using the AS statement in the query, does not work. The wrong "week_nbr" is inserted -- always the number from the top record in the table, it appears. I know that in the case of relational tables, it is possible to output the id from one table to the foreign key in the related table. It is this facility I need to find, somehow, even though I am not dealing with the ids. These are my reasonings at the moment. But there is probably a better, more elegant way to accomplish the needed match. Thanks again for your willingness to help. Curt L. Gustafsson ----- Original Message ----- From: forums@adobe.com To: gustafsson@ibtnet.org Sent: Thursday, May 31, 2007 7:31 PM Subject: Dreamweaver Support subscription update. Newsgroup User has posted a message entitled Re: Dreamweaver MX extracting week number. Message Posted on: Thursday May 31,2007 10:31:12 AM curtgus wrote: > In the process of submitting that date, I want a portion of it (the > "week-number" represented by the date that the user entered) to be submitted to > another field (week_nbr) in the same MySQL database and table. You don't need to. The information stored in datBegin already contains that information, as you point out yourself. > The formating of the week number is not a problem. It is done with > DATE_FORMAT(datBegin,'%u'). You're approaching the problem the wrong way. You presumably want to store the week number so that you can search according to week number or display results by week number. The way to do it is to use DATE_FORMAT(datBegin,'%u') as part of your query. For example: SELECT thisCol, thatCol, DATE_FORMAT(datBegin,'%u') as week_num FROM mytable ORDER BY week_num DESC -- David Powers, Adobe Community Expert Author, "Foundation PHP for Dreamweaver 8" (friends of ED) Author, "PHP Solutions" (friends of ED) http://foundationphp.com/ You can view the message at http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?catid=189&threadid=1272474&forumid=12. ... View more