![]() SELECT * FROM Account WHERE name = Get Started Todayĭownload a free, 30-day trial of the CData JDBC Driver for It produces a table populated with Sybase IQ data!Īs a note, the CData JDBC Drivers also support parameterized queries using the cfqueryparam element. Price" align="Left" width=15 text="Price"/>įull code, including the HTML portion is available below:ĬData Software | Sybase IQ Products Table Demo įinally, run the code locally in a browser at the default port of 8500. ProductName" align="Left" width=2 text="ProductName"/> The following code queries the data source:Īnd a CFTable can be used to quickly output the table in HTML: Next, create a new ColdFusion Markup file (.cfm) and place it in the wwwroot directory ("C:\ColdFusion2021\cfusion\wwwroot") When the data source reports an "OK" status, it is ready for use. Now, test the connection by clicking the check mark to the left of the CDataSybase IQJDBC data source you just created. The Driver Name is arbitrary and simply used to recognize the data source in the ColdFusion administration console. Jdbc:sybaseiq:User=myuser Password=mypassword Server=localhost Database=Northwind A typical connection string looks like this:.For our JDBC driver, choose "other", then click the "Add" button. The data source name can be any name, provided it conforms to the ColdFusion ![]() This is true for both the trial and full versions.įrom the ColdFusion administrator interface, choose Data
0 Comments
Leave a Reply. |