Forum Replies Created

Viewing 15 posts - 1 through 15 (of 15 total)

  • RE: STOPLIST Key Word

    Hi Paul-

    Yes, all of my logic was originally built without bracket qualifiers. The complete tale is: We recently upgraded the database in accordance with the migration instructions provided...

  • RE: STOPLIST Key Word

    Hi,

    Yes, If the database is saved in SQL server 2008 (100) compatibility mode, then It makes NO difference if I bracket the host, database, schema and table names in...

  • RE: STOPLIST Key Word

    Hi Barry,

    It is a simple "generic error". I have a screen shot of it a few posts above this one. It seems to have something to do with...

  • RE: STOPLIST Key Word

    It is getting curiouser and curiouser! I looked at the database and it was in 2008 (100) compatibility mode. I dropped it to 2005 (90) compatibility mode, and the...

  • RE: STOPLIST Key Word

    Hi Everyone. I have full server rights (OS and SQL) on the host. The screenshot is a capture of the error I am getting. Full text is...

  • RE: Yet another pivot question

    Thanks Everyone! This is what I am going with:

    TRUNCATE TABLE WEBAPPDATA ---Truncate while testing only

    INSERT INTO WEBAPPDATA ( FIELDNAME

    ...

  • RE: Yet another pivot question

    Hi Nevyn,

    Yes, I only need it for one form. I am looking over your example again. You are correct: the form is dynamic, so that different fields show...

  • RE: Yet another pivot question

    TomThomson (3/16/2014)


    I'm not at 100% sure, but it looks to me as if the only tables you need to look at are `791650_moc_content`.drupal_Re7RA_webform_submitted_data and `791650_moc_content`.drupal_Re7RA_webform_component. Maybe you have to...

  • RE: Yet another pivot question

    Nevyn (3/15/2014)


    I'm pretty sure a solution is possible, but you have to give us table definitions. You can make up the sample data but it needs to have all fields.

    Also,...

  • RE: Yet another pivot question

    Nevyn (3/15/2014)


    kmdavisjr (3/14/2014)


    Yes, it is bad. I am pulling the data from MySQL database. I do have a submission ID so I can tell who's who, but...

  • RE: Yet another pivot question

    Yes, it is bad. I am pulling the data from MySQL database. I do have a submission ID so I can tell who's who, but the submission...

  • RE: Yet another pivot question

    Awesome! Thanks! I wish I could get the stupid thing normalized. I am getting the data from an ETL operation off a webpage application form, so I am...

  • RE: Cannot Create Full Text Index

    I believe I got it running again by uninstalling the database engine and then reinstalling it.

  • RE: Cannot Create Full Text Index

    I fixed the problem by uninstalling the Full Text Engine from the DB engine, (control Panel), then I reinstalled the FT Engine. Dunno why I lost it in the...

Viewing 15 posts - 1 through 15 (of 15 total)