another IDC syntax error.

another IDC syntax error.

Post by Hungry Horac » Fri, 16 Oct 1998 04:00:00



Hi Guys,

I'm hoping one of you can help me again please.  This time I see to have an
extra '(' but I can't see what's wrong.

Here is the offending IDC file.

Datasource:learningcurve
Template:lcselectdata.htx
SQLStatement:SELECT Table1.School, Table1.Teacher, Table1.AddDate,
Table1.ClassName, Table1.Assignment, Table1.Comment, Table1.Extra
+FROM Table1
+WHERE (((Table1.School)=%[enterschool]%) AND
((Table1.Teacher)=%[enterteacher]%));

It returns the following error.......

Error Performing Query
[State=37000][Error=-3100][Microsoft][ODBC Microsoft Access 97 Driver]
Extra ) in query expression '(((Table1.School)=) AND ((Table1.Teacher)=))'.

Apologies if I'm being a thikky, as ever your help is most appreciated.

regards,

Horace

 
 
 

1. Need help with IDC program flow control syntax

Hello!
I have a database of documents (on MS SQL 6.5), and I need to implement
an HTML form which allows the user to select a document according
to project code. For this purpose a drop down menu to choose the
document, and textbox for the project code is used (see HTML below).

<input type="text" size="5" maxlength="5" name="project_code">
           <select name="formtype" size="1">
                <option selected value="FM160">FM160</option>
                <option value="FM010">FM010</option>
                <option value="FM020">FM020</option>
                <option value="FM030">FM030</option>
                <option value="FM170">FM170</option>
            </select>
        This will then execute an IDC file. However, each document
requires a separate query to extract it from the database, and a
separate HTX file to display the results.
        My initial attempt for the idc file looks like this:
+if %formtype% = FM010
+begin
+  {query for FM010 goes here}
+end
+else
+if %formtype% = FM160
+begin
+ {query for FM160 goes here}
+end
        and so on.....
        Alas, this only results in error messages to the effect that FM010 etc
are invalid column names. What would be the correct syntax? Also, what
program
flow logic should I use in the htx file to display the document in its
particular
format? Or is there some way of choosing between different htx templates
within
the idc file?
        All advice is desperately welcomed :)
--
Regards,
Danielle

2. SQL 2000 server name change

3. IDC syntax using (UPPER)

4. anyone used Choreo (Data Director) with SQL Server?

5. Syntax error w/ no error in syntax.

6. Can you fire a DTS from a Trigger?

7. Syntax ok, but I get syntax error...

8. ADO Recordsource

9. Syntax error in view but syntax is correct

10. ASP/IDC Error

11. [Error=1909] SQL 6.5 and IDC/HTX files

12. IDC user unknown - Error:Access denied.

13. IDC error