• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Posting from CSV to DB but CSV titles have spaces in them, cannot escape?

#3
[eluser]Aken[/eluser]
I'd recommend sanitizing the table's column names into lowercase w/ underscores. Using spaces, capitalization, etc. isn't recommended in naming conventions for databases, for reasons like this. You can then do the same with the feed.

As long as the names are identical, sanitizing them into a proper format shouldn't require changing the feed - you just need to revamp the column names into a different format.

Otherwise worst case scenario, you can create the query manually and escape it however you need.


Messages In This Thread
Posting from CSV to DB but CSV titles have spaces in them, cannot escape? - by El Forum - 07-04-2012, 10:40 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.