CFMX and IIS 1

[ausi]

Hi All,

I installed Cold Fusion MX and am using the stan alone server that comes with MX. My question is do I still need IIS and the PWS installed? I am running Windows 2000 Pro. My pages are displaying fine when I preview them in a browser but I am having to pull my hair out trying to submit data to an Access database. The old cfinsert tags will not work in MX so changed my insert statement to this:

<!-- Insert New Record -->
<cfquery name=&quot;land_add&quot; Datasource=&quot;goldkey&quot;>
Insert Into listings (catagory, ref_number, address, city, long_description, zoned, lot_length, acres, price, mainpic, view, edit, delete)
Values('#Form.catagory#','#Form.ref_number#',#Form.address#,'#Form.city#','#Form.long_description#',#Form.zoned#,#Form.lot_length#,#Form.acres#,'#Form.price#',#Form.mainpic#,#Form.view#,'#Form.edit#','#Form.delete#')
</cfquery>
<!-- End Insert -->

This still did not work I get this error:

Error Executing Database Query.
[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.

The error occurred in C:\CFusionMX\

http://wwwroot\GoldKey\addedit\Land_AddAction.cfm:

line 50

48 : </table>
49 : </body>
50 : </html>

Now what the heck does that mean. An error on line 50??? Is it because I do not have IIS installed? Please help.

Thank You!

Tim

 

[SidianConsulting]

To answer your first question, no, you don't need IIS installed.

The error you are getting is more than likely regarding datatype issues. From what I can see, or should I say assume, your Address field variable needs single quotes around it:

'#Form.address#'

You might get another syntax error in your insert statement afterwards. This would be because some of your datatypes are not qualified right, meaning some might need single quotes around them and some might not.

The problem with the supplied CFML database commands (cfinsert, cfupdate) is that they allow the programmer to forgo the need to learn the SQL equivalents, which are far more efficient and easier to manipulate depending on what you need to do. In my opinion, everyone should avoid them and learn SQL, since it's just as important as knowing your CFML.

-Tek

 

[ausi]

Tek,

Looks like I have to hit the books and learn more about SQL and databases. At least now I know I do not need IIS installed. Thank you for your help.