Hi coldfused,
I found your question from 7/2005 where you were looking for advice about migrating from Access to SQL.
http://www.tek-tips.com/viewthread.cfm?qid=1097761&page=2
I'm trying to do the same thing now and could use your help. I've having a *itch of a time finding info.
Any help...
To ALL forum members,
I joined this forum several years ago and have been helped out of that "stuck, spinning my wheels" place I end up in every so often.
A lot of you have gotten me going again; whether by my reading your previous posts or by you answering a post that I placed.
Each time I...
The ALFII site was a great help. Especially after I read the directions to Tools/Options/View and ticked on System Objects
Problem is that the MSysObjects table belongs to the
owner = "Engine"
(my other tables owner = "Admin")
and ColdFusion returns this error:
[Microsoft][ODBC Microsoft...
I'm not sure what you mean when you refer to
"show tables"
I only want to return the results of one table at a time.
And I'm passing the final query to the database via FORM.variables
My current FORM asks for
First the TableName
Once provided, it prompts to Select the Columns to display
Then...
Hi all,
Is there a way to get a list of table names in an Access database using Cold Fusion?
I would like to be able to then loop through each table and output the column names using #QueryName.ColumnList#.
And then, of course the values using #Evaluate(ThisColumn)#
BTW: Happy New Year
well my logs tell me that only a small percentage of my users are still using older versions of Netscape.
I'll just have to convince them to upgrade.
Thank you for all your help. You're a life saver.
I'm obviously a novice at Javascript. I would appreciate any help/push in the right direction.
Thanks in advance
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>Javascript - Preview as you type</title>
<meta http-equiv="Content-Type" content="text/html...
The function cfusion_disable_dbconnections takes 2 arguments(s).
Can anyone please tell me what they are.
My book says this function is undocumented.
Thanks in advance.
Thanks Crystal for pointing me in the right direction.
Here's the code that made it work for anyone who is interested.
Any suggestions on how to make it more efficient are welcome.
<cfquery name="ProductPrices" datasource="secret">
SELECT quantity, customer_price
FROM...
The problem is that the GetPricing query can return lots of rows.
How can one distinguish within the row being returned at that moment AND the values returned in the PREVIOUS rows ?
<cfoutput query="GetPricing">
<cfif qty LTE #CurrentQty#>
<tr bgcolor="yellow"><!---...
Wullie,
Since the group order total(550) has surpassed the pricing structure of the 500 quantity level but not yet attained the 1000 level, the current unit price for all the orders placed so far is at the 500 level. The UnitPrice is no longer $10 or $8, but it has not yet reached the minimum...
I need to narrow down a result set based on a number.
I can't explain it well in words, but please read on... the queries/code should tell all.
<!--- Pricing Structure based on quantity levels --->
<cfquery name="GetPricing" datasource="secret">
SELECT *
FROM...
I need to set up a site so that users are authenticated and allowed access only if they clicked on a link on a certain page... such as a link placed on an Intranet.
Passing a URL variable via the Intranet link is NOT an option because the variable would be visible to the user.
I checked...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.