Quote:
Originally Posted by slugmandrew
Yeah, I think it's a little long-winded, but it'll do for now. Can I also just ask why you used stripslashes in your example? Is it run before htmlspecialchars so that the slashes aren't converted into special characters? I wasn't sure if i should apply it to the account fields as well before updating.
I read that on $_POST variables addslashes() is run automatically if magic_quotes_gpc is on so maybe I should? Ok it seems to work fine. Sorry this is turning into a monologue.
Coming back to the topic of this post, I've now used your SQL replication script to create a copy of my own salesforce instance (developer's account) which has 85 tables, and another created from your complete schema (90 tables). I have also used the account update script to update both SQL databases with all current accounts and it works great!
We mainly use salesforce to manage leads and accounts at the moment, so i'm going to see if i can modify your script to create a local copy of all leads. I actually feel like I am getting closer to having our own copy of our salesforce data!
You have an absolute goldmine here. I reckon this site will be heaving in a year's time. Thanks again.
|
I used stripslashes on some of the fields coming out of Oracle because they were large text fields, some CLOB's that had lots of stuff that needed to be cleaned. I think that is why I used it, also I applied to the array_map so it would handle all the $rows
So the MySQL tool to create your local schema worked for you okay? Did you see or have any problems with it? If so, please do let me know