Ask a Question related to Coldfusion Database Access, Design and Development.
-
InkFasT! #1
Table Replication
Does anyone know how the following code can be modified to produce all data in
one table instead of the page replicating tables? I'm trying to access the data
from an external program and will only look at 1 table....
CODE:
<CFQUERY DATASOURCE="datasource" NAME="authorize">
SELECT businessname, username, date
FROM authorize
ORDER BY businessname, username, date
</CFQUERY>
<CFOUTPUT QUERY="authorize">
<table width="100%" border="0">
<tr> <font face="Arial" size="2">
<td width="400" valign="top"><p>#businessname#</p>
</td>
<td width="400" valign="top"><p>#username#</p>
</td>
<td width="400" valign="top"><p>#date#</p>
</td>
</font> </tr>
</table>
</CFOUTPUT>
RESULT:
<body>
<table width="100%" border="0">
<tr> <font face="Arial" size="2">
<td width="400" valign="top"><p>Developer</p>
</td>
<td width="400" valign="top"><p>test2</p>
</td>
<td width="400" valign="top"><p>2005-10-09 15:27:32.0</p>
</td>
</font> </tr>
</table>
<table width="100%" border="0">
<tr> <font face="Arial" size="2">
<td width="400" valign="top"><p>Programmer</p>
</td>
<td width="400" valign="top"><p>test1</p>
</td>
<td width="400" valign="top"><p>2005-10-09 15:27:07.0</p>
</td>
</font> </tr>
</table>
</body>
InkFasT! Guest
-
Replication
Hi, Check the last couple of checkpoints on the primary and secondary servers - they should be within seconds of each other (assuming the clocks... -
File Replication
Hi There I have content on a windows 2003 server (server1) that I need to replication to another windows 2003 server (server2). I would like... -
DB2 V7 replication
Hi, How many ways are there to replicate data with DB2 V7 from Windows to linux? Thanks in advance, Ming -
One way replication
Help We want to have a DB2 server that expose to the internet for read only. And one internal server for Read & write. Is there a way to... -
Could not load type VTFixup Table from assembly Invalid token in v-table fix-up table.
We are getting this error after clearing the web.config of database infomation - even after using the wizard to re-enter the information. I could... -
philh #2 Re: Table Replication
Hi InkFast!,
Put the table tags outside of the CFOUTPUT section.
HTH,
philh Guest
-
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
