ttp://awads.net/wp/2005/08/19/your-sql-tool/
http://awads.net/wp/2005/10/12/your-sql-tool-part-ii/
http://www.freelists.org/archives/oradev/08-2005/msg9.html
HTH
--
Eddie Awad.
http://awads.net/
~|
Logware (www.logware
f seconds.
--
Eddie Awad.
http://awads.net/
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion
On 10/4/05, Taco Fleur <[EMAIL PROTECTED]> wrote:
> Or if on a lower version of CF you could use the WAITFOR command in SQL
> within a cfquery tag..
That would be in MS SQL Server, right?
--
Eddie Awad.
http
Database? version? table structure? sample data? ...
--
Eddie Awad.
http://awads.net/
On 8/25/05, Che Vilnonis <[EMAIL PROTECTED]> wrote:
> If have a query that returns a 24 hour breakdown of orders by the hour on a
> monthly basis. (see below).
> As you can see, Hour 5 & 6
> Can you create an index to a view created with SQL?
In Oracle, a view is nothing but a stored select statement. Tables
store data, views do not (unless they are materilized views). So, you
do not index views, but you index the tables that the views select
from.
--
Eddie Awad.
http://awads.
an excellent (and free) mailing lists service that
can do it for you. However, the lists are all Internet and
technology-related. Check it out at http://www.freelists.org/
In fact, I have created a mailing list there for Oracle developers:
http://www.freelists.org/webpage/oradev
Cheers
--
Eddi
s a date:
mm-dd-yy
1-1-12
12-34-17 (but 34 is not a valid day??)
All the strings that work for you do not fall into this format. Again,
it's just an observation.
--
Eddie Awad.
http://awads.net/
~|
Logware (www.logware.u
tood each other. I was referring to Oracle's
implementation.
No harm done :)
--
Eddie Awad.
http://awads.net/
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and document
st.oracle.com/docs/cd/B10501_01/server.920/a96524/c13datyp.htm
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96624/03_types.htm
--
Eddie Awad.
http://awads.net/
~|
Logware (www.logware.us): a new and conveni
hen you can use the LEVEL, CONNECT BY and START
WITH in your query. The LEVEL would be equivalent to the depth.
Something like (untested):
SELECT name,fullname,parentFolder,totalMessages, LEVEL
FROM results.folders
CONNECT BY parentFolder = PRIOR fullname
START WITH parentFolder = ...your parent fold
boolean?
Oracle's PL/SQL Boolean data type does not have an equivalent in
ColdFusion, I think this may be because "Boolean" is not a native SQL
data type. So, what I usually end up doing is to change the data type
of the Boolean argument in my stored procedure to something li
n.nl/horror.txt?
--
Eddie Awad.
http://awads.net/
~|
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 i
at shows you how to get the image dimensions:
http://awads.net/wp/2005/06/16/get-image-dimensions/. You can modify
it to use img.getScaledInstance() to resize the image. I have not
tested this but it is something you may want to explore further. HTH.
--
Eddie Awad.
http
like that, and I just return #courses# then
> it returns an empty array.
> What am I doing wrong?
use listToArray(valueList(getCourses.title))
--
Eddie Awad.
http://awads.net/
~|
Find out how CFTicket can increase your
2-234-3455
>
> I need it to look like this:
> 1212 North Street
> Chicago
> 232-234-3455
>
> Anyone have any ideas on how to get the line breaks in there?
Have you tried appending a carriage return/line feed to the end of
each line? like this:
FORM.address & CHR(13) &
= s.food_store_id
AND g.gi_id = #cookie.fsnep_bargain_hunt_gi_id#
GROUP BY p.si_id,s.food_store_id
--
Eddie Awad.
http://awads.net/
~|
Find out how CFTicket can increase your company's customer support
7; , 'Pork', 15 , 16
);
select max(depth)
from (
select level as depth from t
connect by parent = prior title
start with parent is null
)
The above query returns 4.
--
Eddie Awad.
http://awads.net/
~|
Logware (www.log
for that need. I was just stating an idea
because that's how I would do it. And by the way, I forgot to put a
"commit" after the "insert" in the example procedure in my previous
e-mail.
--
Eddie Awad.
http://awads.net/
end;
/
Then in ColdFusion:
#id_out#
Of course, you could also just create a "when-insert" trigger on the
table to automatically populate the id column so you do not have to
worry about it in your "insert"
the rows unless you explicitly say "for
update of" followed by a list of columns.
--
Eddie Awad.
http://awads.net/
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking
was helpful. Have a
nice weekend.
--
Eddie Awad.
http://awads.net/
~|
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
s relatively well other times it
> performs very poorly.
Sounds like some SQL tuning may be required here!
Ya all have a good weekend ...
--
Eddie Awad.
http://awads.net/
~|
Find out how CFTicket can increase your company
escue:
aAccountNumber
12345
bAddress
USA
Account Number: #accountNumber[1].xmlText#
Address: #address[1].xmlText#
If you have multiple account number nodes, you would need to loop over
the array accountNumber[]. Same applies to the array address[]
." Read
the whole technote here:
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=9ce734f4
--
Eddie Awad.
http://awads.net/
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application.
On 7/6/05, Anthony Prato <[EMAIL PROTECTED]> wrote:
>Now I'm wondering how to use coldfusion to post xml
--
Eddie Awad.
http://awads.net/
~|
Discover CFTicket - The leading ColdFusion Help Desk and T
t
> as a simple value as I am attempting to do here with
> "#variable.myXMLName[1].XmlText#"?
Don't know what you mean.
--
Eddie Awad.
http://awads.net/
~|
Find out how CFTicket can increase your company's
er than that, nothing broke. In fact, because CFMX7 has some nice
new features, I have spent more time modifying pages to take advantage
of the new version's capabilities than to fix things.
--
Eddie Awad.
http://awads.net/
~~
27 matches
Mail list logo
