Hi all, OS X 10.8.2 DW v 12 I have setup a mamp database w mysql and have it sucessfully doing things inside of a DW PHP site I'm working on. Other older dynamic pages are working ok. I already have a working connection. I already have a testing server using local folder. ISSUE: If I create a new blank page test.php and then try to go to the server behaviors tab and create something - well the plus sign is grayed out and asks me to do the 4 items to set up a dynamic site... which I already did... Also I can click + in Bindings and it will allow me to create a recordset from there - is that normal? So maybe I set something up wrong in site management or something like that? ... View more

Hi all, I posted this here: http://forums.adobe.com/message/4779510#4779510 but I realized it probably is smarter to put it here instead.... -------------- Hi all, I'm trying to get the databases and bindings panels working on a site... I already have things setup and working for a colfusion 10 & mysql site.... local deveopment server an mac lion.... So - when I preview a page in browser or DW live mode - all mysql data show just fine but the databases tab is gray and tell 5 things to do - but they are allready done in site setup area... --> site setup uses connect = local / network but maybe need to switch to RDS instead??? I am using application.cfm master page with main connection data. I do not have a connection folder - because previously not needed It's like DW needs to see application.cfm data? Q: what is missing? How do I get the databases panel working? ... View more

Hi all, I'm trying to get the databases and bindings panels working on a site... I already have things setup and working for a colfusion 10 & mysql site.... local deveopment server an mac lion.... So - when I preview a page in browser or DW live mode - all mysql data show just fine but the databases tab is gray and tell 5 things to do - but they are allready done in site setup area... --> site setup uses connect = local / network but maybe need to switch to RDS instead??? I am using application.cfm master page with main connection data. I do not have a connection folder - because previously not needed It's like DW needs to see application.cfm data? Q: what is missing? ... View more

Hi All, I'm rusty at this - need some help... here's my files on mac- ... Applications/ColdFusion9/wwwroot/main/site1 how do I set the testing server up in DW? local site ... /Applications/ColdFusion9/wwwroot/main/site1 testing server server field - i put... /Applications/ColdFusion9/wwwroot/main/site1 web URL... http://localhost:8500/site1/ then I test in browser: http://localhost:8500/site1/test.cfm but it fails with : FILE NOT FOUND but this works but not what i want http://localhost:8500/site1/test.cfm I WANT the sub folder also! What's wrong ? ... View more

Hi All, The line below adds a comma and text to the end of the varchar field in MS SQL... UPDATE thetable SET thefield = thefield+','+'#trim(Form.newitem)#' Where id = 1 ...  but errors in MySQL 5 ... Error Executing Database Query. Data truncation: Truncated incorrect DOUBLE value: ',' BTW: I tried: thefield = thefield & ',' & '#trim(Form.newitem)#' --- but still errors out Q: Is there  a better way to write this statement for MySQL so it won't have an error? ... View more

Hi Folks, I'm having TIMESTAMP issues moving from MS SQL to MySQL 5 i got the schema and data moved from MS sql to MySQl 5 - the date field in my sql table is set to datetime - the content is like: 2004-02-05 14:31:00 but looks like: 2004-02-05 14:31:00.0 (extra .0) - when displayed raw in CF 8 on a page - when I query the table, I get this error: Error Executing Database Query. Cannot convert value '0000-00-00 00:00:00' from column 24 to TIMESTAMP.             - I tried to use the type timestamp instead but that did not help? Q: How do I fix this error? Thanks in advance! ... View more