out of sync?
So, in testing, if changes are made to the database then I'd have to replicate those changes in our hosted database as a seperate action? Harumpff! :(
That's a real nuisance because we will have to recreate umpteen tables and views simply for testing purposes when we already have them created in our hosted database. Is there any quick fix to that?
I'm quite happy always connecting to the hosted database however in the Dreamweaver Bindings tab we can't expand our recordsets to check fields, change field formats. It's a real pain!
For example, before (classic asp / mssql) we would simply select a field from our recordset and Dreamweaver would allow us choose a format for it from a list.
I only discovered this because I was trying to display an INT field as currency:
<?php echo $row_rsPRODS['LEDprice']; ?>
So, digging around on Google we tried this...
<?php echo money_format($row_rsPRODS['LEDprice']); ?>
...but that just produces errors. It's frustrating because I know Dreamweaver has simple ways of doing this but because we can't use our live database, whilst working locally, we can't access these tools.
It seems odd to me that you'd need to create two data sources just to create one database driven website. Surely what ends up happening is that the two become out of sync, no?
Appreciate the help and advice, as ever. Thank you.