Welcome Guest, Not a member yet? Register   Sign In
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



Theme © iAndrew 2016 - Forum software by © MyBB