Search results for query: *

Hi. Let's say I have a CFQUERY: <CFQUERY NAME="qMyQuery"> SELECT * FROM myTable </CFQUERY> and the results of that query are in the thousands and I don't want to output them all at the same time for performance issues (page load, etc). My thought was to do: <CFQUERY NAME="qMyQuery"...

Hi folks, As a basic and limited user of Oracle and databases, I'm wondering what you would suggest as the best workaround for the varchar2 4000 char limit. Knowing that I will have textual data that needs to be saved that will be more than 4,000 characters, how would you suggest handling...

Hi folks. I do basic and some intermediate SQL querying a lot, but the solution to this query escapes me... i'm not sure how to accomplish this. Could someone lend a hand? Let's say I have two tables, with the following columns: grades_tbl: id, grade_lvl, grade_txt programs_tbl: id...

Hi folks, I'm a little lost on this one. I tried reading the forums for an answer but couldn't find one that worked. If I have a field called title_level, and it can contains values such as A, B, C, 1, 2, 3... I want to sort results so that they'd be listed as: A C 1 3 11 14 . . . I've got...

Hi folks, I have a bunch of strings that are missing spaces, and I want to insert spaces every time I encounter a capital letter. I'm having a bit of a pickle trying to figure this out. Could someone lend some advice? Many thanks. An example is: "AWarmDay" I want to convert to "A Warm Day"...

Hi all, Somewhat new to ASP. I have a script that needs to be prepared for any number of grade_# variables... for example: grade_1 grade_2 ... grade_n Simple psuedo-code is: Dim i i=1 While grade_i exists ' do something i=i+1 Wend I'm not sure how to a) make asp treat grade_i as a...

Hi, If i have a variable i, set to "1", which would be output as <CFOUTPUT>#i#</CFOUTPUT> And I have a variable 1, set to "yes", which would be output as <CFOUTPUT>#1#</CFOUTPUT> How could I use the value of i to check the valoue of 1.. meaning, <CFOUTPUT>##i##</CFOUTPUT> (which doesn't work...

Good afternoon, If I have a table in which are two colums job1 and job2. Both have the same possible values (ie job1 can be either cook, tv host, or sales and job2 can be ither cook, tv host, or sales). I want to create a querie that says select DISTINCT jobs from job1 and job2... meaning...

Hi, If I have a table in which are two colums job1 and job2. Both have the same possible values (ie job1 can be either cook, tv host, or sales and job2 can be ither cook, tv host, or sales). I want to create a querie that says select DISTINCT jobs from job1 and job2... meaning, give me a list...

Hi, Could anyone advise me how to go about doing this? I want to make it so that if a user uses any of the following URLs (as an example): www.fakeurl.com/brazil www.fakeurl.com/usa www.fakeurl.com/mexico they will all wind up at country_app.cfm, which will analyze the URL and do something...

Is there a way to do a for-each or something similar and look for UNIQUE values? IE - say my XML was: <xml> <item id=&quot;1&quot;/> <item id=&quot;1&quot;/> <item id=&quot;2&quot;/> <item id=&quot;3&quot;/> <item id=&quot;3&quot;/> </xml> Could I do a query that returns some...

Hi. I'm wondering, can I perform an <xsl:sort> that examines two things? IE - say I have a node like this: <question chapter=&quot;1&quot; number=&quot;1&quot;/> And there are dozens of these <questions> in the XML doc. I want to sort first by chapter, then - by number within chapter. So, all...

First, example code :) XML: <quiz> <question narrative=&quot;1&quot;> <text>This is a question.</text> <ref>104</ref> </question> <question narrative=&quot;3&quot;> <text>This is a question.</text> <ref>098</ref> </question> <question...

Hi all. OK - what I've got is an XML file which I'm simplifying right here, so you can have a frame of reference: <test> <narrative id=&quot;1&quot;>Write True or False on the line.</narrative> <narrative id=&quot;2&quot;>Write the answer using complete sentences.</narrative> <question...

Hi all, I want to find some information online about how to go about building a Jukebox in Flash that will search a XML file for MP3s and play them within the Flash. None of the MP3s would be embedded within the Flash - but would reside in an /audio folder. The XML file would contain...

Hi all... I can't figure this out for the life of me. I've got a Flash applet that uses an XML document to pull the filename and path of an MP3 file, load it into the Flash applet, and play it. It works on Mac, all browsers. It works on PC with Netscape and Opera. However, on PC with Internet...

Sorry to ask this. I'm new at creating XSLT's, and I just want to get this simple task to work. :) I've rewritten my &quot;XML&quot; and &quot;XSLT&quot; in really dumbed down, simple structure below. My Question follows... Here's my XML: <examview> <question> <text>...

Hi, Let's say I've got a mySQL Table with 5 text-type fields. A user fills out a standard HTML form, entering the text data s/he wants to store in these mySQL fields. When I process the form using PHP, I want to make sure that the data does not contain any characters that would screw me up...

Hi. I was wondering... is it possible to store an array in a table? How would I do that? Say I had an array ques_array... and it contained, for brevity's sake: quest_array[1]=&quot;Some text&quot; quest_array[2]=&quot;Some text&quot; quest_array[3]=&quot;Some text&quot; Could I store that...

Hi. I'm trying to have my PHP code add a field to a table. I'm not sure what I'm doing wrong, so if you could take a look at this code and perhaps let me know, I'd appreciate it. Here's what I've written: $query_add_field=mysql_query(&quot;ALTER TABLE 'wickersty'.'team_roster' ADD...