ODBC Error Code = S1C00 (Driver not capable)
what do you make of this... ODBC Error Code = S1C00 (Driver not capable) [Microsoft][ODBC SQL Server Driver]Optional feature not implemented error when i try exectuting a stored procedure with an odbc sql server driver for the dsn. sql server 2000, cf5, btw the dsn is verifiable and will execute inline sql without a problem. i have a feeling i'm missing something that's probably obvious, so forgive the duh-factor on this ;) ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210979 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfscript looping over udf's
i am looping over a query - inside the loop, i am calling a udf that calls
another udf...
for( i = 1; i lte qQuery.RecordCount; i = i+1 ) {
WriteOutput(DrawRow(qQuery.colA[i]), Trim(qQuery.colB[i])));
}
function DrawRow(someNo, someAmt) {
var rRow = ;
var thisRow = SetValue(someNo, someAmt);
for( i = 1; i lte ArrayLen(thisRow); i = i+1 ) {
rRow = rRow 'td align=right class=' IIf(thisRow[i] lt 0,
DE(negative), DE()) '';
rRow = rRow IIf(thisRow[i] gt 0, DE(DecimalFormat(thisRow[i])),
DE(nbsp;)) '/td';
}
return rRow; // return a string
}
function SetValue(someNo, someAmt) {
switch (someNo) {
case 082: {
aRow[1] = someAmt;
break;
}
case 126: {
aRow[2] = someAmt;
break;
}
case 153: {
aRow[3] = someAmt;
break;
}
case 176: {
aRow[4] = someAmt;
break;
}
case 301: {
aRow[5] = someAmt;
break;
}
}
return aRow; // return an array
}
however, the call to the DrawRow() udf in the query loop works for the first
iteration, then breaks out of the loop therfore ignoring any subsequent records.
does anyone see a possible reason for this?
at first i thought it maybe the use of break in the case statements in the
SetValue udf, so i changed to using if/else if, but that produced the same
results.
i also tried using global variables instead of function-local vars for the
array - still no luck.
it really seems as though something wacked is happening after the first
iteration of the query loop that is causing the loop to end prematurely, but i
can seem to pin it down.
this is in cf5 btw cringe
tia!
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210375
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfscript looping over udf's
function SetValue(someNo, someAmt) {
oops - that should read...
function SetValue(someNo, someAmt) {
var aRow = ArrayNew(1);
ArraySet(variables.aRow, 1, 5, 0);
// switch/case statements
return aRow;
}
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210379
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfscript looping over udf's
You didn't declare i in DrawRow() with the var keyword -- that's your
problem, since it's overwriting the variable i you're using to loop
over the query...
duh - thanks everyone - i just changed the i to var j for more clarity and it
works perfectly with the following code...
for( i = 1; i lte qQuery.RecordCount; i = i+1 ) {
WriteOutput(DrawRow(qQuery.colA[i]), Trim(qQuery.colB[i])));
}
function DrawRow(someNo, someAmt) {
var j = 0;
var rRow = ;
var thisRow = SetValue(someNo, someAmt);
for( j = 1; j lte ArrayLen(thisRow); j = j+1 ) {
rRow = rRow 'td align=right class=' IIf(thisRow[j] lt 0,
DE(negative), DE()) '';
rRow = rRow IIf(thisRow[i] gt 0, DE(DecimalFormat(thisRow[j])),
DE(nbsp;)) '/td';
}
return rRow; // return a string
}
function SetValue(someNo, someAmt) {
var aRow = ArrayNew(1);
ArraySet(aRow, 1, 5, 0);
switch (someNo) {
case 082: {
aRow[1] = someAmt;
break;
}
case 126: {
aRow[2] = someAmt;
break;
}
case 153: {
aRow[3] = someAmt;
break;
}
case 176: {
aRow[4] = someAmt;
break;
}
case 301: {
aRow[5] = someAmt;
break;
}
}
return aRow; // return an array
}
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210409
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
msdn comparison of cf to asp.net
just wondered what the list thinks of this msdn article - do you think the comparison is fair/accurate? http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaspp/html /coldfusiontoaspnet.asp ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204565 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Is BlueDragon.NET the greatest thing since sliced bread?
i agree w/jordan - vince is a well-respected community advocate and bd is something that the community at large should be aware of and informed about. i think that a discussion about whether the post is an advertisement or not (blatant, thinly-veiled, or otherwise) is moot - newatlanta is creating milestones in the cf world, imho, and i am interested in what vince has to say about their product. cf-talk is the authoritative portal for disseminating relevant information to the community and i consider vince's post valid and relative. just my opinion - not a flame. Jim probably just didn't realize that this post was from someone who represents a leader in the CF community who only intends to talk about CF-related stuff. If some joe off the street started making posts about their blog in here I might have the same reaction Jim did. ;) -JM Adrian Lynch wrote: -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200307 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
ooa, ood, oop and design patterns
i've been reading alot of blogs lately that are beginning to seriously address and examine the new frontier of oo-ness that cfmx has introduced to us as cf developers. i love it and would like to see more - in fact, i was wondering if it is now time to devote a list that can aggregate our communal thoughts on these concepts and create an open discussion and learning forum for those that are interested. it would be great to see cf communities begin to develop centered around the oo mentality - for instance, lists devoted oo analisys, design, programming, design patterns, architectures, frameworks, etc. discussing tools and methodologies for good oo implementation - for example, i'd love to see ideas/experiences on utilising uml and any of the various methodologies related to sound ooa/ood. given - the path from procedural cf to oo cf is a tough one to tred - but for those of us who have made the journey, i'd like to cultivate a community to nurture that effort (before it's long over-due)! thoughts? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200318 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ooa, ood, oop and design patterns
thanks joe - will check it out. btw, your blog has been a great resource. greatly admire your insight. i have been long silent in the community, but hope to contribute more going forward (as i can - you know how that goes). kudos on model-glue! brian ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200331 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
