In your query, get rid of the single quotes.
it should look like this....
<cfquery name="Datos" datasource="SGBD_SIPLA" dbtype="ODBC"
username="podsd" password="23524" >
Select C01010, C01015 from SIG00010 where C01010 =7327720
</cfquery>
Ryan Edgar
Web Applications Developer
Biznet Solutions
133 - 137 Lisburn Road
Belfast
BT9 7AG
www.biznet-solutions.com
Tel: +44 (0)28 9022 3224
Fax: +44 (0)28 9022 3223
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 31 July 2001 11:38
To: CF-Talk
Subject: Newbie question
Hi all
I've got a problem and I can't solve it.
I'm trying to follow a book example
That is the code:
<html>
<head><title>Coldfusion Informe Barcos</title></head>
<body>
<!-- Coldfusion query -->
<cfquery name="Datos" datasource="SGBD_SIPLA" dbtype="ODBC"
username="podsd" password="23524" >
Select C01010, C01015 from SIG00010 where C01010 ='7327720'
</cfquery>
<cfoutput query="Datos">
<P>Lloyd : #C01010#<br>
<P>Eslora : #C01015#<br>
</cfoutput>
</body>
</html>
And that's what I obtain:
Select C01010, C01015 from SIG00010 where C01010 ='7327720'
Lloyd : #C01010#
Eslora : #C01015#
The book says that we should obtain the values which correspond with
those fields.It seems like ColdFusion doesn't recognize his tags
I don't know why
Can anybody tell me what could be happenig?
Thanks in advance
Best regards
Manuel
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
