School Assignment? Project Due Tomorrow? Chat LIVE With A Programming Expert!

Programming Help

Web Development



What's Here?

  • Members: 307,160
  • Replies: 841,934
  • Topics: 140,708
  • Snippets: 4,468
  • Tutorials: 1,165
  • Total Online: 1,506
  • Members: 95
  • Guests: 1,411

Welcome to Dream.In.Code
Become an Expert!

Join 307,160 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 1,506 people online right now. Registration is fast and FREE... Join Now!




retrieve profiles from the database

 

retrieve profiles from the database
akandiah

5 Aug, 2009 - 03:02 PM
Post #1

New D.I.C Head
*

Joined: 5 Aug, 2009
Posts: 2
Hi there,
I am new to coldfusion. Could you please anyone help why I am getting the following error.

Attribute validation error for tag CFQUERY.
The tag does not allow the attribute(s) DATASOURE. The valid attribute(s) are BLOCKFACTOR,CACHEDAFTER,CACHEDWITHIN,CONNECTSTRING,DATASOURCE,DBNAME,DBPOOL,DBSE
RVER,DBTYPE,DEBUG,MAXROWS,NAME,PASSWORD,PROVIDER,PROVIDERDSN,RESULT,SQL,TIMEOUT,
USERNAME.

may ColdFusion code is:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Recall Data from Friends Table</title>
</head>

<body>
<CFQUERY NAME="data" DATASOURE="friends">
SELECT LastName, FirstName FROM friends
</CFQUERY>

<TABLE border="1">

<CFOUTPUT QUERY="data">
<TR><TD>#data.FirstName# #Data.LastName#</TD>
</CFOUTPUT>
</TABLE>


</body>
</html>
User is offlineProfile CardPM
+Quote Post


Posts in this topic
akandiah   retrieve profiles from the database   5 Aug, 2009 - 03:02 PM
ComboAlex   I am not sure, but maybe you should change the DAT...   6 Aug, 2009 - 07:52 AM
xheartonfire43x   I am not sure, but maybe you should change the DA...   7 Aug, 2009 - 11:42 AM

 Fast ReplyReply to this topicStart new topic

Time is now: 11/21/09 05:54PM
Invision Power Board v2.1.7 © 2009  IPS, Inc.
Licensed to: MediaGroup1

Live Help!

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter Fan Us On Facebook

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month