I am currently developing a webpage in ASP using a lot of ADO, and therefore, SQL. This would be all fine and dandy, if it weren't for the insanely convoluted database system we have at my workplace.
--Skip this part if you don't want the backstory--
You see, my boss came up with this brilliant "content management system" which regular Joes could use to update their webpages without knowing a single bit of code. the problem is, the database solution he came up with is the most backasswards thing I think I've ever seen.
I have to query several tables to get the info I need. Got that, INNER JOIN, done. the issue is, to make the database as confusing as possible, my boss is using multiple data types in each column. I have filtered the records by their "ItemID," so I'm only getting the relevant ones, but these records contain, all in the same column, all sorts of things like, dates, names, descriptions, etc. I want to pick out, from the records that match my "ItemID," only the ones whose "SubItemContent" contains a date. Is that possible?
--Ok, start reading again--
Too long, didn't read?
here's what I want the query to do (simplified and in my non-SQL lingo):
SELECT * FROM Modules WHERE ItemID = 123 AND SubItemContent datatype = date
Soo... How do I do that?
--Skip this part if you don't want the backstory--
You see, my boss came up with this brilliant "content management system" which regular Joes could use to update their webpages without knowing a single bit of code. the problem is, the database solution he came up with is the most backasswards thing I think I've ever seen.
I have to query several tables to get the info I need. Got that, INNER JOIN, done. the issue is, to make the database as confusing as possible, my boss is using multiple data types in each column. I have filtered the records by their "ItemID," so I'm only getting the relevant ones, but these records contain, all in the same column, all sorts of things like, dates, names, descriptions, etc. I want to pick out, from the records that match my "ItemID," only the ones whose "SubItemContent" contains a date. Is that possible?
--Ok, start reading again--
Too long, didn't read?
here's what I want the query to do (simplified and in my non-SQL lingo):
SELECT * FROM Modules WHERE ItemID = 123 AND SubItemContent datatype = date
Soo... How do I do that?