Programming Help

Web Development



What's Here?

  • Members: 105,763
  • Replies: 404,438
  • Topics: 61,340
  • Snippets: 2,214
  • Tutorials: 596
  • Total Online: 1,704
  • Members: 68
  • Guests: 1,636

Who's Online?

Welcome to Dream.In.Code
Getting Help is Easy!

Join 105,763 Programmers for FREE! Ask your question and get quick answers from experts. There are 1,704 online right now! We've got more than 500 tutorials and 2,000 snippets. Join and find out why Dream.In.Code is the #1 programming help community on the internet! Registration is fast and FREE... Join Now!



how coldfusion connect t to oracle

 
 Reply to this topicStart new topic

how coldfusion connect t to oracle
roslin164
post 27 Feb, 2008 - 08:24 PM
Post #1


New D.I.C Head

*
Joined: 24 Feb, 2008
Posts: 6


My Contributions
hai...i want to know how to connect Coldfusion with oracle databace? If somebody can give more tips.Thanx a lot... smile.gif
User is offlineProfile CardPM

Go to the top of the page


eflores
post 6 Mar, 2008 - 09:29 PM
Post #2


New D.I.C Head

*
Joined: 28 Dec, 2007
Posts: 1
QUOTE(roslin164 @ 27 Feb, 2008 - 08:24 PM) *

hai...i want to know how to connect Coldfusion with oracle databace? If somebody can give more tips.Thanx a lot... smile.gif


in the cf administrator, create a new data source:
1) name your data source
2) select "oracle" as your driver
3) click add
4) input your server information, and user information
5) click submit

that should create your data source

then,
when yoy write your code, specify the data source name you defined in the cfquery tag like such

CODE

<cfquery name="myQuery" datasource="dsName">
        SELECT *
        FROM tablename
</cfquery>
User is offlineProfile CardPM

Go to the top of the page

roslin164
post 10 Mar, 2008 - 12:02 AM
Post #3


New D.I.C Head

*
Joined: 24 Feb, 2008
Posts: 6


My Contributions
Thanx a lot eflores.....i'll learn more the notes... smile.gif
User is offlineProfile CardPM

Go to the top of the page

Fast ReplyReply to this topicStart new topic
Time is now: 8/21/08 01:37PM
Invision Power Board v2.1.7 © 2008  IPS, Inc.
Licensed to: MediaGroup1

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

Bye Bye Ads

Free DIC T-Shirt

T-Shirt Example

Related Sites

Monthly Drawing

Thumb Drive

Partners

Top Contributors

Top 10 Kudos This Month