Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. NorthStarDA

    dynamic number of columns - but not hard coded

    hey thanks for the response, i am using coldfusion on this project and figured that i could use coldfusion to generate the selects i need, the problem though is how to get that result without looping over the entire recordset to build the values, that would be slow. i'm thinking of doing a...
  2. NorthStarDA

    dynamic number of columns - but not hard coded

    hi, i have a database of contacts and surveys, my software is similar to surveymonkey.com where i let people create and use surveys. i need to allow users to export the survey data but since this system is entirely automated, i need to query the survey data without hard-coding any survey...
  3. NorthStarDA

    Sync'ing cfm pages between repositories

    yeah i'm gonna agree with Phil- if it is your responsibility to fix this then it's your responsibility to put in processes that make your software less vulnerable. i've heard this argument a thousand times and i'm also in the middle of it with a client of mine- it's always the same: "We're too...
  4. NorthStarDA

    DISTINCT COUNT WITH NULL VALUES (GRAND TOTAL)

    you are so in the wrong forum, try asking in the forum corresponding to the database that you are using. ========================================= Don't sweat the petty things and don't pet the sweaty things.
  5. NorthStarDA

    CFCHART - Multiple values, multiple elements over time

    i would group it by date, for instance if you were using a column chart, each day would be a point on the X axis and you could use a multi-series (stacked columns) to show each element in that day. your 'value' being on the y axis. does this help? =========================================...
  6. NorthStarDA

    Auto FIll

    what does this have to do with coldfusion? you have to use javascript <input id="fieldA" onkeyup="document.getElementById('fieldB').value = this.value" /> <input id="fieldB" /> something like that. ========================================= Don't sweat the petty things and don't pet the...
  7. NorthStarDA

    sub query returns multiple values (and i want it to)

    I have no sql to show really, just a general question. One column in my query is derived from a sub query SELECT .., (SELECT..) as col FROM etc.. The subselect might return 3 records (which will throw an error), but what i want it to do is return 1 row with the 3 values it brought back...
  8. NorthStarDA

    cfml2js with multiple returns?

    well i don't really get what you're doing here without some code examples, i'm assuming your talking about some sort of ajaxian application if the issue is concurrency. if that is the case then you must be returning your JS as a string to be evaluated before another request is made. if so then...
  9. NorthStarDA

    cfml2js with multiple returns?

    maybe im not getting you, but why don't you just write that single js var out to the page as you normally would? cfwddx cfml to js is great for creating JS objects, not single vars - even if it could do it, there's really no reason for it. ========================================= Don't sweat...
  10. NorthStarDA

    Getting rid of the last comma in a cfoutput query

    you dont.. your original example loops over a query where you output each single value with a comma - this function does not require the loop, it gets all values from that column of your query and comma-separates them for you. if your not familiar with the function, look it up on liveDocs for a...
  11. NorthStarDA

    Getting rid of the last comma in a cfoutput query

    instead of doing a query output, can you do a ValueList()? #ValueList(QofQ.color)# that will put commas where they go. ========================================= Don't sweat the petty things and don't pet the sweaty things.
  12. NorthStarDA

    Operation aborted - why though? :/

    try to take your script blocks out of the table, i know it sounds weird but i've had this same issue before and apparently in some weird situations IE does not like script blocks inside a table. put them just above your closing body tag and see how that works out...
  13. NorthStarDA

    Ringtones

    i've never done it, but adobe says you can send ringtones to cell phones with the sms gateway. http://www.adobe.com/devnet/coldfusion/articles/smsgateway.html ========================================= Don't sweat the petty things and don't pet the sweaty things.
  14. NorthStarDA

    Ping to see if I can connect to a server

    and on another note, if that were possible to do this - you can use the 'variable' attribute to grab the program output. ========================================= Don't sweat the petty things and don't pet the sweaty things.
  15. NorthStarDA

    Ping to see if I can connect to a server

    Really?? I can only imagine the kind of havoc i could wreak if I could call executables on client computers. I'm not an authority on the matter having never used cfexecute myself, but that does not seem right. ========================================= Don't sweat the petty things and don't pet...
  16. NorthStarDA

    Show SQL command (syntax)

    in CFMX 7 the cfquery tag has a new attribute called 'result'. you assign it the variable name you want to give it, then use it however you wish. <cfquery datasource="#foo#" name="#bar#" result="#myResult#"> .... </cfquery> <cfdump var="#myResult#"> There are a few variables it gives you...
  17. NorthStarDA

    backup and restore from script

    it would be possible for me to do with a shell script, i can execute batch files etc.. from coldfusion - it's just not pretty and does not give me enough control as far as error checking and such. however, your second option just might do the trick! i wonder if i can query the...
  18. NorthStarDA

    backup and restore from script

    hi, I have mysql 5 running as the db for my coldfusion application. This particular application needs to make a copy of a certain db and restore it with a new name. I have seen mysqlhotcopy but i need something that i can use from a cfquery tag in CF, can this be done...
  19. NorthStarDA

    binaryread and loadfromfile methods

    maybe you're looking for <cffile action="readbinary"> http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=part_cfm.htm ========================================= Don't sweat the petty things and don't pet the sweaty...
  20. NorthStarDA

    Using CFMail

    rsvirani, maybe i'm missing something but i've not known any smtp server to act that way. just to make sure i'm not crazy i just composed a mail message to myself and a made up email address of something i know is not a working mail box. i received the message i sent to myself and a mail...

Part and Inventory Search

Back
Top