Search results

Hi, I have a feeling I'm missing something very basic here... grateful for a steer. I have a series of IDs in an 'articles' table stored as text, e.g. hb-123456789-e-068 hb-123456789-e-0069 hb-123456789-e-70 hb-123456789-e-00027 and I'm trying to pull the max value of the number after the...

Hi, I have two tables, Articles and Versions, related 1 to many. In my Versions table I want to set up a field that will start at 0 for the first version record related to an article record, and as version records are added in relation to that same article record I want it to increment by 1...

Hi, I have a table with two fields, articleID and relatedArticleID. They are both primary keys to prevent duplicate combinations of the pair. This is linked, one-to-many, to the articles table. I want to find where a relationship only exists in one direction but not the other. For example...

Hi, I have a database with 8 tables, and I need to export each as an XML file. 7 out of 8 XML files export ok. With one table, the XML file only includes 2,613 records, while the table in the database has 27,561 records. Any idea what's causing this? I've exported this table successfully in...