Anybody tried this before? How do I get around this (aside from manually adding the field in later)?
Thanks,
Brett
Adding a type 'SET' as a mySQL type isn't working!
Adding a type 'SET' as a mySQL type isn't working!
I am trying to add a type 'SET' to my database table and the database module is removing the "('Sent', 'Received')" portion of my field list which is causing mysQL to give back an error!
Anybody tried this before? How do I get around this (aside from manually adding the field in later)?
Thanks,
Brett
Anybody tried this before? How do I get around this (aside from manually adding the field in later)?
Thanks,
Brett
-
Pierre M.
Re: Adding a type 'SET' as a mySQL type isn't working!
Hello Brett,
Is your question CMSms specific or is it rather a question for the MySQL support forum ?
Pierre M.
I don't understand how this would be CMSms linked. What is this "database module" ?genepilot wrote: I am trying to add a type 'SET' to my database table and the database module is removing the "('Sent', 'Received')" portion of my field list which is causing mysQL to give back an error!
Is your question CMSms specific or is it rather a question for the MySQL support forum ?
Pierre M.
Re: Adding a type 'SET' as a mySQL type isn't working!
It is CMSMS related because it is part of the process to create a table for CMSMS. I have been creating queries for mySQL for years that successfully add a type SET to mySQL tables. But, whenever I try using the process to create a table that is built into CMSMS, I always get back an error.
I can't believe that nobody else in here has never had a need to create a table that has a type of SET within it. It isn't like it's a rare thing in the database world and it is actually a better way of doing it than I see among the module code because searching for SET values in a query is faster than searching for Strings, and if you index them the index for a SET is much smaller than an index for a String.
I can't believe that nobody else in here has never had a need to create a table that has a type of SET within it. It isn't like it's a rare thing in the database world and it is actually a better way of doing it than I see among the module code because searching for SET values in a query is faster than searching for Strings, and if you index them the index for a SET is much smaller than an index for a String.
Pierre M. wrote: Hello Brett,
I don't understand how this would be CMSms linked. What is this "database module" ?genepilot wrote: I am trying to add a type 'SET' to my database table and the database module is removing the "('Sent', 'Received')" portion of my field list which is causing mysQL to give back an error!
Is your question CMSms specific or is it rather a question for the MySQL support forum ?
Pierre M.
Last edited by genepilot on Mon Apr 27, 2009 7:21 pm, edited 1 time in total.
Re: Adding a type 'SET' as a mySQL type isn't working!
I don't believe that the data abstraction layer that CMSMS uses, ADODB (lite), has a field type "SET".
However, you may want to browse through the ADODB manual and forums to find a solution.
Nullig
However, you may want to browse through the ADODB manual and forums to find a solution.
Nullig
Re: Adding a type 'SET' as a mySQL type isn't working!
Correct, this is an adodb lite issue. Most database abstractions try to not use things that are totally database specific -- especially data types like SET. Varchar(10) would work just as well and wouldn't be mysql specific. However, it's something you'd have to take up with them.
