[cfaussie] Re: Why we can NOT see our user group (APUGS) at first place?
I vote Kai to tell 'em. getting a German-born New Zealander to tell the Americans that they've made a mistake has to be interesting reading in somebody' book... On Tue, Jul 21, 2009 at 3:57 PM, Kai Koenigk...@bloginblack.de wrote: I all seriousness, I think that's a mistake on the group admin's end. Hawaii doesn't belong to the Adobe Pacific region but the North American region :) Cheers Kai On 21/07/2009, at 5:35 PM, Kym Kovan wrote: Barry Beattie wrote: don't the Yanks own Hawaii? I seem to remember a movie called Pearl Harbour Not if you're a surfer, separate country then :-) -- Yours, Kym Kovan mbcomms.net.au _ Kai Koenig - Ventego Creative Ltd ph: +64 4 476 6781 - mob: +64 21 928 365 / +61 450 132 117 web: http://www.ventego-creative.co.nz blog: http://www.bloginblack.de --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Why we can NOT see our user group (APUGS) at first place?
Dude, for various reasons I can't make things worse anyway, happy to push it to them :-) Cheers Kai I vote Kai to tell 'em. getting a German-born New Zealander to tell the Americans that they've made a mistake has to be interesting reading in somebody' book... On Tue, Jul 21, 2009 at 3:57 PM, Kai Koenigk...@bloginblack.de wrote: I all seriousness, I think that's a mistake on the group admin's end. Hawaii doesn't belong to the Adobe Pacific region but the North American region :) Cheers Kai On 21/07/2009, at 5:35 PM, Kym Kovan wrote: Barry Beattie wrote: don't the Yanks own Hawaii? I seem to remember a movie called Pearl Harbour Not if you're a surfer, separate country then :-) -- Yours, Kym Kovan mbcomms.net.au _ Kai Koenig - Ventego Creative Ltd ph: +64 4 476 6781 - mob: +64 21 928 365 / +61 450 132 117 web: http://www.ventego-creative.co.nz blog: http://www.bloginblack.de _ Kai Koenig - Ventego Creative Ltd ph: +64 4 476 6781 - mob: +64 21 928 365 / +61 450 132 117 web: http://www.ventego-creative.co.nz blog: http://www.bloginblack.de --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: barcode magnetic stripe readers in forms
I have never tried this. Do you know for sure that the barcode and magnetic stripe value would be returned as comma seperated? From: d...@fraser.id.au To: cfaussie@googlegroups.com Subject: [cfaussie] Re: barcode magnetic stripe readers in forms Date: Tue, 21 Jul 2009 14:10:18 +1000 Cant you just accept them into a single form field and pull it apart afterwards Regards Dale Fraser http://dale.fraser.id.au http://learncf.com http://flexcf.com From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Mark Ireland Sent: Tuesday, 21 July 2009 1:11 PM To: cfaussie@googlegroups.com Subject: [cfaussie] barcode magnetic stripe readers in forms I have used a barcode scanner to populate a field in a form but . . .. I need to get both the barcode and the values in the magnetic stripe on the back of the card into a form. I found a card reader that does both at once but I need to know if anyone has successfully used one to get both values into a form in one swipe. Sell your car fast. Need a new model in your life? _ Need a new model in your life? Sell your car fast. http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fsecure%2Dau%2Eimrworldwide%2Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801459%2Fpi%5F1004813%2Fai%5F866383_t=758314219_r=carpoint_tagline_m=EXT --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: barcode magnetic stripe readers in forms
do you have to know it is going to be a comma? Barcodes are usually numbers so.. cfset seperator = LEFT(1, REReplace(barcode, [^[:alpha:]], , ALL)) / That will give you what ever is seperating the numbers _ From: Mark Ireland [mailto:markinc...@hotmail.com] Sent: Tuesday, 21 July 2009 4:50 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: barcode magnetic stripe readers in forms I have never tried this. Do you know for sure that the barcode and magnetic stripe value would be returned as comma seperated? _ From: d...@fraser.id.au To: cfaussie@googlegroups.com Subject: [cfaussie] Re: barcode magnetic stripe readers in forms Date: Tue, 21 Jul 2009 14:10:18 +1000 Cant you just accept them into a single form field and pull it apart afterwards Regards Dale Fraser http://dale.fraser.id.au http://learncf.com http://flexcf.com From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Mark Ireland Sent: Tuesday, 21 July 2009 1:11 PM To: cfaussie@googlegroups.com Subject: [cfaussie] barcode magnetic stripe readers in forms I have used a barcode scanner to populate a field in a form but . . .. I need to get both the barcode and the values in the magnetic stripe on the back of the card into a form. I found a card reader that does both at once but I need to know if anyone has successfully used one to get both values into a form in one swipe. _ Sell your car fast. Need http://a.ninemsn.com.au/b.aspx?URL=http://secure-au.imrworldwide.com/cgi-bi n/a/ci_450304/et_2/cg_801459/pi_1004813/ai_866383_t=758314219_r=carpoint_t agline_m=EXT a new model in your life? _ Sell your car fast. Need a new model in your http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fsecure%2Dau%2Eimrworldwide% 2Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801459%2Fpi%5F1004813%2F ai%5F866383_t=758314219_r=carpoint_tagline_m=EXT life? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: barcode magnetic stripe readers in forms
Even if they are not, the barcode is a fixed length so you can split it. Regards Dale Fraser http://dale.fraser.id.au http://learncf.com http://flexcf.com From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Mark Ireland Sent: Tuesday, 21 July 2009 4:50 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: barcode magnetic stripe readers in forms I have never tried this. Do you know for sure that the barcode and magnetic stripe value would be returned as comma seperated? _ From: d...@fraser.id.au To: cfaussie@googlegroups.com Subject: [cfaussie] Re: barcode magnetic stripe readers in forms Date: Tue, 21 Jul 2009 14:10:18 +1000 Cant you just accept them into a single form field and pull it apart afterwards Regards Dale Fraser http://dale.fraser.id.au http://learncf.com http://flexcf.com From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Mark Ireland Sent: Tuesday, 21 July 2009 1:11 PM To: cfaussie@googlegroups.com Subject: [cfaussie] barcode magnetic stripe readers in forms I have used a barcode scanner to populate a field in a form but . . .. I need to get both the barcode and the values in the magnetic stripe on the back of the card into a form. I found a card reader that does both at once but I need to know if anyone has successfully used one to get both values into a form in one swipe. _ Sell your car fast. Need http://a.ninemsn.com.au/b.aspx?URL=http://secure-au.imrworldwide.com/cgi-bi n/a/ci_450304/et_2/cg_801459/pi_1004813/ai_866383_t=758314219_r=carpoint_t agline_m=EXT a new model in your life? _ Sell your car fast. Need a new model in your life? http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fsecure%2Dau%2Eimrworldwide% 2Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801459%2Fpi%5F1004813%2F ai%5F866383_t=758314219_r=carpoint_tagline_m=EXT --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Post without Email?
Is there some magic trick to making a message post with my name instead of email displaying? -- Thank you, Randy M. Zeitman (610) 259-4123 The Philadelphia Web Design Company - We Give Small Business a Big Voice ! http://philadelphia-web-design.com/ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Post without Email?
Or do you mean your phone number? I see that showing up on the from field for you, Randy. :-) Anyway, I do believe this is controlled on the google groups page, whose URL is always offered at the bottom of each message: http://groups.google.com/group/cfaussie?hl=en If you are logged in there (with whatever google account whose email address is where you're receiving the group messages), you'll see an option on the right for edit my membership, and on that page there's an input field asking, What nickname do you want people in this group to see? I'm pretty sure that would control what you're looking for. Let us know, Randy. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Randy Zeitman - (610) 259-4123 Sent: Tuesday, July 21, 2009 3:02 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Post without Email? Is there some magic trick to making a message post with my name instead of email displaying? -- Thank you, Randy M. Zeitman --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] XML Import Issue
Hi guys.
Got an XML import issue. I am trying to import an XML file but I'm having
issues with some nodes not being defined in the XML. For example the node
'duration' may not be define for every record in the XML file. So I need to
check to see if the node exists before I reference it, if it does not exist
then I want to set it as null. I have tried isdefined and few other but can't
seem to get the correct terminology. Code sample below
cffile action=read file=d:\Data\wwwroot\misd\XML\modelbuildparms.xml
variable=xmlfile
cfscript
xmlfile = trim(xmlfile);
xmlfile = xmlparse(xmlfile);
xmlsize =
xmlfile.body.GetListItemsResponse.GetListItemsResult.listitems.data.XmlAttributes.ItemCount;
xmlqry = QueryNew(Title, ModelPath, ModelEmailString, CubePublishPath,
PPESPublishPath, ModelUserSecurity, ModelBuildExtraCommandsPre,
ModelBuildExtraCommandsPost, BuildLevel, BusinessName, Duration, Keywords,
NotifyStatus, MajorGrouping, MinorGrouping, ModelLabel, Frequency, Status,
PrimaryMDC, ItemType, Path, UpdateTimeStamp, CreatedBy, ModifiedBy, Created,
Modified, ID);
QueryAddRow(xmlqry,100);
for (a=1; a LTE 1; a=a+1) {
QuerySetCell(xmlqry,title,
xmlfile.body.GetListItemsResponse.GetListItemsResult.listitems.data.row[a].XmlAttributes.ows_Buildlevel,a);
QuerySetCell(xmlqry,ModelPath,
xmlfile.body.GetListItemsResponse.GetListItemsResult.listitems.data.row[a].XmlAttributes.ows_ModelPath,a);
)
/cfscript
In this example I need to check to see if the
'xmlfile.body.GetListItemsResponse.GetListItemsResult.listitems.data.row[a].XmlAttributes.ows_Buildlevel'
node exists before I reference it.
Thanks
Brian Knott
Software Engineer (COGNOS Developer) | MIS Front End | Banking Life MIS
ext 31221 ph 07 1221
This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its
related entities Suncorp.
Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11
55 or at suncorp.com.au.
The content of this e-mail is the view of the sender or stated author and does
not necessarily reflect the view of Suncorp. The content, including
attachments, is a confidential communication between Suncorp and the intended
recipient. If you are not the intended recipient, any use, interference with,
disclosure or copying of this e-mail, including attachments, is unauthorised
and expressly prohibited. If you have received this e-mail in error please
contact the sender immediately and delete the e-mail and any attachments from
your system.
If this e-mail constitutes a commercial message of a type that you no longer
wish to receive please reply to this e-mail by typing Unsubscribe in the
subject line.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to
cfaussie+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---
[cfaussie] Re: XML Import Issue
Perhaps use a try-catch statement to initialise a variable, then use
it instead.
e.g.
try {
tempTitle =
xmlfile.body.GetListItemsResponse.GetListItemsResult.listitems.data.row
[a].XmlAttributes.ows_Buildlevel ;
}
catch (Any e) {
tempTitle = '' ;
}
On Jul 22, 8:32 am, KNOTT, Brian brian.kn...@suncorp.com.au wrote:
Hi guys.
In this example I need to check to see if the
'xmlfile.body.GetListItemsResponse.GetListItemsResult.listitems.data.row[a].XmlAttributes.ows_Buildlevel'
node exists before I reference it.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to
cfaussie+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---
[cfaussie] Re: XML Import Issue
Just regular old structKeyExists should do it for you.
if(
StructKeyExists(xmlfile.body.GetListItemsResponse.GetListItemsResult.listitems.data.row[a].XmlAttributes,
ws_Buildlevel)
)
{
doSomething();
}
On Tue, Jul 21, 2009 at 6:32 PM, KNOTT, Brian brian.kn...@suncorp.com.auwrote:
Hi guys.
Got an XML import issue. I am trying to import an XML file but I’m having
issues with some nodes not being defined in the XML. For example the node
‘duration’ may not be define for every record in the XML file. So I need to
check to see if the node exists before I reference it, if it does not exist
then I want to set it as null. I have tried isdefined and few other but
can’t seem to get the correct terminology. Code sample below
cffile action=read file=d:\Data\wwwroot\misd\XML\modelbuildparms.xml
variable=xmlfile
cfscript
xmlfile = trim(xmlfile);
xmlfile = xmlparse(xmlfile);
xmlsize =
xmlfile.body.GetListItemsResponse.GetListItemsResult.listitems.data.XmlAttributes.ItemCount;
xmlqry = QueryNew(Title, ModelPath, ModelEmailString,
CubePublishPath, PPESPublishPath, ModelUserSecurity,
ModelBuildExtraCommandsPre, ModelBuildExtraCommandsPost, BuildLevel,
BusinessName, Duration, Keywords, NotifyStatus, MajorGrouping,
MinorGrouping, ModelLabel, Frequency, Status, PrimaryMDC, ItemType, Path,
UpdateTimeStamp, CreatedBy, ModifiedBy, Created, Modified, ID);
QueryAddRow(xmlqry,100);
for (a=1; a LTE 1; a=a+1) {
QuerySetCell(xmlqry,title,
xmlfile.body.GetListItemsResponse.GetListItemsResult.listitems.data.row[a].XmlAttributes.ows_Buildlevel,a);
QuerySetCell(xmlqry,ModelPath,
xmlfile.body.GetListItemsResponse.GetListItemsResult.listitems.data.row[a].XmlAttributes.ows_ModelPath,a);
)
/cfscript
In this example I need to check to see if the
‘xmlfile.body.GetListItemsResponse.GetListItemsResult.listitems.data.row[a].XmlAttributes.ows_Buildlevel’
node exists before I reference it.
Thanks
*Brian Knott*
Software Engineer (COGNOS Developer) | MIS Front End | Banking Life MIS
*ext* 31221* ph* 07 1221
* *
This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of
its related entities Suncorp.
Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13
11 55 or at suncorp.com.au.
The content of this e-mail is the view of the sender or stated author and
does not necessarily reflect the view of Suncorp. The content, including
attachments, is a confidential communication between Suncorp and the
intended recipient. If you are not the intended recipient, any use,
interference with, disclosure or copying of this e-mail, including
attachments, is unauthorised and expressly prohibited. If you have received
this e-mail in error please contact the sender immediately and delete the
e-mail and any attachments from your system.
If this e-mail constitutes a commercial message of a type that you no
longer wish to receive please reply to this e-mail by typing Unsubscribe in
the subject line.
--
-- if you've written a homegrown[*CFML] controller layer that rivals the
sophistication and ease of use of the three major players (MG/MII/FB) - then
share it or shut up. You code in a silo - that's great. Just stay in there
and don't try to tell everyone how good it smells.
--Dave Ross
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to
cfaussie+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---
[cfaussie] Re: XML Import Issue
Perfect.
I knew if I just asked the question I would save my self a lot of stuffing
around.
Brian Knott
ext 31221
From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of
Kevin Pepperman
Sent: Wednesday, 22 July 2009 8:47 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: XML Import Issue
Just regular old structKeyExists should do it for you.
if(
StructKeyExists(xmlfile.body.GetListItemsResponse.GetListItemsResult.listitems.data.row[a].XmlAttributes,
ws_Buildlevel)
)
{
doSomething();
}
On Tue, Jul 21, 2009 at 6:32 PM, KNOTT, Brian
brian.kn...@suncorp.com.aumailto:brian.kn...@suncorp.com.au wrote:
Hi guys.
Got an XML import issue. I am trying to import an XML file but I'm having
issues with some nodes not being defined in the XML. For example the node
'duration' may not be define for every record in the XML file. So I need to
check to see if the node exists before I reference it, if it does not exist
then I want to set it as null. I have tried isdefined and few other but can't
seem to get the correct terminology. Code sample below
cffile action=read file=d:\Data\wwwroot\misd\XML\modelbuildparms.xml
variable=xmlfile
cfscript
xmlfile = trim(xmlfile);
xmlfile = xmlparse(xmlfile);
xmlsize =
xmlfile.body.GetListItemsResponse.GetListItemsResult.listitems.data.XmlAttributes.ItemCount;
xmlqry = QueryNew(Title, ModelPath, ModelEmailString, CubePublishPath,
PPESPublishPath, ModelUserSecurity, ModelBuildExtraCommandsPre,
ModelBuildExtraCommandsPost, BuildLevel, BusinessName, Duration, Keywords,
NotifyStatus, MajorGrouping, MinorGrouping, ModelLabel, Frequency, Status,
PrimaryMDC, ItemType, Path, UpdateTimeStamp, CreatedBy, ModifiedBy, Created,
Modified, ID);
QueryAddRow(xmlqry,100);
for (a=1; a LTE 1; a=a+1) {
QuerySetCell(xmlqry,title,
xmlfile.body.GetListItemsResponse.GetListItemsResult.listitems.data.row[a].XmlAttributes.ows_Buildlevel,a);
QuerySetCell(xmlqry,ModelPath,
xmlfile.body.GetListItemsResponse.GetListItemsResult.listitems.data.row[a].XmlAttributes.ows_ModelPath,a);
)
/cfscript
In this example I need to check to see if the
'xmlfile.body.GetListItemsResponse.GetListItemsResult.listitems.data.row[a].XmlAttributes.ows_Buildlevel'
node exists before I reference it.
Thanks
Brian Knott
Software Engineer (COGNOS Developer) | MIS Front End | Banking Life MIS
ext 31221 ph 07 1221
This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its
related entities Suncorp.
Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11
55 or at suncorp.com.auhttp://suncorp.com.au.
The content of this e-mail is the view of the sender or stated author and does
not necessarily reflect the view of Suncorp. The content, including
attachments, is a confidential communication between Suncorp and the intended
recipient. If you are not the intended recipient, any use, interference with,
disclosure or copying of this e-mail, including attachments, is unauthorised
and expressly prohibited. If you have received this e-mail in error please
contact the sender immediately and delete the e-mail and any attachments from
your system.
If this e-mail constitutes a commercial message of a type that you no longer
wish to receive please reply to this e-mail by typing Unsubscribe in the
subject line.
--
-- if you've written a homegrown[*CFML] controller layer that rivals the
sophistication and ease of use of the three major players (MG/MII/FB) - then
share it or shut up. You code in a silo - that's great. Just stay in there and
don't try to tell everyone how good it smells.
--Dave Ross
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to
cfaussie+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---
[cfaussie] Attached vs. embedded (cfmail, multipart/mixed, attachments, embedded image)
I want to send a mail which has a PDF attachment and an embedded image. When I send them both with cfmailparam (with correct disposition) they arrive in the email as attachments in the body...you don't get the little email paperclip attachment icon. When I tried using mimeattach for the PDF it did work!...but the image denoted with cfmailparam also came through like that. So I looked the email headers of both and the good one was Content-Type: multipart/ mixed; while the bad one was multipart/related. So how can I make cfmailparam send it as multipart/mixed? (if that's even the right question...maybe I should stick with mimeattach and do something else?) Thanks Folks' - Randy --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Inserting Queries
Guys having a slow brain day. I have a query that I have created from code using the QueryNew command. I now want to insert this into a database, something like cfquery name=data datasource=SQLServer INSERT INTO databaseTable SELECT Title, title as Modelname, ModelPath, ModelEmailString, CubePublishPath, PPESPublishPath, ModelUserSecurity, ModelBuildExtraCommandsPre, ModelBuildExtraCommandsPost, BuildLevel, BusinessName, Duration, Keywords, NotifyStatus, MajorGrouping, MinorGrouping, ModelLabel, Frequency, Status, PrimaryMDC, ItemType, Path FROM queryInMomory /cfquery Thanks Brian Knott Software Engineer (COGNOS Developer) | MIS Front End | Banking Life MIS ext 31221 ph 07 1221 This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its related entities Suncorp. Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 55 or at suncorp.com.au. The content of this e-mail is the view of the sender or stated author and does not necessarily reflect the view of Suncorp. The content, including attachments, is a confidential communication between Suncorp and the intended recipient. If you are not the intended recipient, any use, interference with, disclosure or copying of this e-mail, including attachments, is unauthorised and expressly prohibited. If you have received this e-mail in error please contact the sender immediately and delete the e-mail and any attachments from your system. If this e-mail constitutes a commercial message of a type that you no longer wish to receive please reply to this e-mail by typing Unsubscribe in the subject line. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Inserting Queries
The easiest way would be to loop over the initial query and either make each DB insert a new inline query, or you can make a cffunction that does the insert and call the method from the loop. eg cffunction name=insertIntoTable cfargument name=value1 / cfargument name=value2 / cfquery datasource=#getDsn()# INSERT INTO .VALUES ( #arguments.value1#, #arguments.value1#) /cfquery /cffunction cfloop query=myQuery cfset insertIntoTable(myQuery.myValue1, myQuery.myValue2) / /cfloop AD HOK CODE!! On Tue, Jul 21, 2009 at 8:21 PM, KNOTT, Brian brian.kn...@suncorp.com.auwrote: Guys having a slow brain day. I have a query that I have created from code using the QueryNew command. I now want to insert this into a database, something like cfquery name=data datasource=SQLServer INSERT INTO databaseTable SELECT Title, title as Modelname, ModelPath, ModelEmailString, CubePublishPath, PPESPublishPath, ModelUserSecurity, ModelBuildExtraCommandsPre, ModelBuildExtraCommandsPost, BuildLevel, BusinessName, Duration, Keywords, NotifyStatus, MajorGrouping, MinorGrouping, ModelLabel, Frequency, Status, PrimaryMDC, ItemType, Path FROM queryInMomory /cfquery Thanks *Brian Knott* Software Engineer (COGNOS Developer) | MIS Front End | Banking Life MIS *ext* 31221* ph* 07 1221 * * This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its related entities Suncorp. Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 55 or at suncorp.com.au. The content of this e-mail is the view of the sender or stated author and does not necessarily reflect the view of Suncorp. The content, including attachments, is a confidential communication between Suncorp and the intended recipient. If you are not the intended recipient, any use, interference with, disclosure or copying of this e-mail, including attachments, is unauthorised and expressly prohibited. If you have received this e-mail in error please contact the sender immediately and delete the e-mail and any attachments from your system. If this e-mail constitutes a commercial message of a type that you no longer wish to receive please reply to this e-mail by typing Unsubscribe in the subject line. -- -- if you've written a homegrown[*CFML] controller layer that rivals the sophistication and ease of use of the three major players (MG/MII/FB) - then share it or shut up. You code in a silo - that's great. Just stay in there and don't try to tell everyone how good it smells. --Dave Ross --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Inserting Queries
Thanks Barry. Could just do a loop, as hoping to do one big insert but you don't seem to be able get data form one datasource and insert into another, in the same cfquery. Brian Knott ext 31221 -Original Message- From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Barry Beattie Sent: Wednesday, 22 July 2009 10:35 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Inserting Queries Hi Brian queryInMomory (sic: momery?) has multiple rows, yes? if so, anything wrong with a loop over the in-memory query doing individual db inserts for each loop iteration? the thing to keep in mind is that the in-memory query is nothing more than a CF memory data structure, not a db query, view or table. basically a struct of arrays. in other words, two different layers, you need to take the data out of the CF layer (in-memory query) and put it into the db layer (inserts into db tables) just a thought barry.b On Wed, Jul 22, 2009 at 10:21 AM, KNOTT, Brianbrian.kn...@suncorp.com.au wrote: Guys having a slow brain day. I have a query that I have created from code using the QueryNew command. I now want to insert this into a database, something like cfquery name=data datasource=SQLServer INSERT INTO databaseTable SELECT Title, title as Modelname, ModelPath, ModelEmailString, CubePublishPath, PPESPublishPath, ModelUserSecurity, ModelBuildExtraCommandsPre, ModelBuildExtraCommandsPost, BuildLevel, BusinessName, Duration, Keywords, NotifyStatus, MajorGrouping, MinorGrouping, ModelLabel, Frequency, Status, PrimaryMDC, ItemType, Path FROM queryInMomory /cfquery Thanks Brian Knott Software Engineer (COGNOS Developer) | MIS Front End | Banking Life MIS ext 31221 ph 07 1221 This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its related entities Suncorp. Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 55 or at suncorp.com.au. The content of this e-mail is the view of the sender or stated author and does not necessarily reflect the view of Suncorp. The content, including attachments, is a confidential communication between Suncorp and the intended recipient. If you are not the intended recipient, any use, interference with, disclosure or copying of this e-mail, including attachments, is unauthorised and expressly prohibited. If you have received this e-mail in error please contact the sender immediately and delete the e-mail and any attachments from your system. If this e-mail constitutes a commercial message of a type that you no longer wish to receive please reply to this e-mail by typing Unsubscribe in the subject line. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Inserting Queries
That's about right. The insert statement is being run on the server in the RDBMS and it knows nothing about your memory query. I am guessing you were getting an SQL error back about a missing table? Kevin has it right :) 2009/7/22 KNOTT, Brian brian.kn...@suncorp.com.au Thanks Barry. Could just do a loop, as hoping to do one big insert but you don't seem to be able get data form one datasource and insert into another, in the same cfquery. Brian Knott ext 31221 -Original Message- From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Barry Beattie Sent: Wednesday, 22 July 2009 10:35 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Inserting Queries Hi Brian queryInMomory (sic: momery?) has multiple rows, yes? if so, anything wrong with a loop over the in-memory query doing individual db inserts for each loop iteration? the thing to keep in mind is that the in-memory query is nothing more than a CF memory data structure, not a db query, view or table. basically a struct of arrays. in other words, two different layers, you need to take the data out of the CF layer (in-memory query) and put it into the db layer (inserts into db tables) just a thought barry.b On Wed, Jul 22, 2009 at 10:21 AM, KNOTT, Brianbrian.kn...@suncorp.com.au wrote: Guys having a slow brain day. I have a query that I have created from code using the QueryNew command. I now want to insert this into a database, something like cfquery name=data datasource=SQLServer INSERT INTO databaseTable SELECT Title, title as Modelname, ModelPath, ModelEmailString, CubePublishPath, PPESPublishPath, ModelUserSecurity, ModelBuildExtraCommandsPre, ModelBuildExtraCommandsPost, BuildLevel, BusinessName, Duration, Keywords, NotifyStatus, MajorGrouping, MinorGrouping, ModelLabel, Frequency, Status, PrimaryMDC, ItemType, Path FROM queryInMomory /cfquery Thanks Brian Knott Software Engineer (COGNOS Developer) | MIS Front End | Banking Life MIS ext 31221 ph 07 1221 This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its related entities Suncorp. Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 55 or at suncorp.com.au. The content of this e-mail is the view of the sender or stated author and does not necessarily reflect the view of Suncorp. The content, including attachments, is a confidential communication between Suncorp and the intended recipient. If you are not the intended recipient, any use, interference with, disclosure or copying of this e-mail, including attachments, is unauthorised and expressly prohibited. If you have received this e-mail in error please contact the sender immediately and delete the e-mail and any attachments from your system. If this e-mail constitutes a commercial message of a type that you no longer wish to receive please reply to this e-mail by typing Unsubscribe in the subject line. -- Cheers Simon Haddon Woman loves feeling danger and speed. That is why woman wants man. They get a speed rush that is the most dangerous of all. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Inserting Queries
If your tables have some type of related index you can also use the undocumented JAVA indexOf() method of the query object. Especially if you will need to run these query's often. Ben Nadel has a case study. http://www.bennadel.com/blog/267-Ask-Ben-ColdFusion-Optimization-A-Case-Study.htm Or better yet use Ben's technique of creating Structures from querys for super fast index lookups. http://www.bennadel.com/blog/268-Structs-As-Query-Indexes-Speed-And-Rick-Osborne.htm http://www.bennadel.com/blog/268-Structs-As-Query-Indexes-Speed-And-Rick-Osborne.htmVery handy for combining query's from separate data sources. On Tue, Jul 21, 2009 at 8:43 PM, Simon Haddon simon.had...@gmail.comwrote: That's about right. The insert statement is being run on the server in the RDBMS and it knows nothing about your memory query. I am guessing you were getting an SQL error back about a missing table? Kevin has it right :) 2009/7/22 KNOTT, Brian brian.kn...@suncorp.com.au Thanks Barry. Could just do a loop, as hoping to do one big insert but you don't seem to be able get data form one datasource and insert into another, in the same cfquery. Brian Knott ext 31221 -Original Message- From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Barry Beattie Sent: Wednesday, 22 July 2009 10:35 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Inserting Queries Hi Brian queryInMomory (sic: momery?) has multiple rows, yes? if so, anything wrong with a loop over the in-memory query doing individual db inserts for each loop iteration? the thing to keep in mind is that the in-memory query is nothing more than a CF memory data structure, not a db query, view or table. basically a struct of arrays. in other words, two different layers, you need to take the data out of the CF layer (in-memory query) and put it into the db layer (inserts into db tables) just a thought barry.b On Wed, Jul 22, 2009 at 10:21 AM, KNOTT, Brianbrian.kn...@suncorp.com.au wrote: Guys having a slow brain day. I have a query that I have created from code using the QueryNew command. I now want to insert this into a database, something like cfquery name=data datasource=SQLServer INSERT INTO databaseTable SELECT Title, title as Modelname, ModelPath, ModelEmailString, CubePublishPath, PPESPublishPath, ModelUserSecurity, ModelBuildExtraCommandsPre, ModelBuildExtraCommandsPost, BuildLevel, BusinessName, Duration, Keywords, NotifyStatus, MajorGrouping, MinorGrouping, ModelLabel, Frequency, Status, PrimaryMDC, ItemType, Path FROM queryInMomory /cfquery Thanks Brian Knott Software Engineer (COGNOS Developer) | MIS Front End | Banking Life MIS ext 31221 ph 07 1221 This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its related entities Suncorp. Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 55 or at suncorp.com.au. The content of this e-mail is the view of the sender or stated author and does not necessarily reflect the view of Suncorp. The content, including attachments, is a confidential communication between Suncorp and the intended recipient. If you are not the intended recipient, any use, interference with, disclosure or copying of this e-mail, including attachments, is unauthorised and expressly prohibited. If you have received this e-mail in error please contact the sender immediately and delete the e-mail and any attachments from your system. If this e-mail constitutes a commercial message of a type that you no longer wish to receive please reply to this e-mail by typing Unsubscribe in the subject line. -- Cheers Simon Haddon Woman loves feeling danger and speed. That is why woman wants man. They get a speed rush that is the most dangerous of all. -- -- if you've written a homegrown[*CFML] controller layer that rivals the sophistication and ease of use of the three major players (MG/MII/FB) - then share it or shut up. You code in a silo - that's great. Just stay in there and don't try to tell everyone how good it smells. --Dave Ross --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Attached vs. embedded (cfmail, multipart/mixed, attachments, embedded image)
This worked for me cfmail to=em...@email from=em...@email subject=mime test cfmailparam file=filetoattach / cfmailparam file=imagefile contentid=image / cfmailpart type=text/html img src=cid:image / /cfmailpart /cfmail -Original Message- From: randzman [mailto:randz...@verizon.net] Sent: Wednesday, 22 July 2009 9:02 AM To: cfaussie Subject: [cfaussie] Attached vs. embedded (cfmail, multipart/mixed, attachments, embedded image) I want to send a mail which has a PDF attachment and an embedded image. When I send them both with cfmailparam (with correct disposition) they arrive in the email as attachments in the body...you don't get the little email paperclip attachment icon. When I tried using mimeattach for the PDF it did work!...but the image denoted with cfmailparam also came through like that. So I looked the email headers of both and the good one was Content-Type: multipart/ mixed; while the bad one was multipart/related. So how can I make cfmailparam send it as multipart/mixed? (if that's even the right question...maybe I should stick with mimeattach and do something else?) Thanks Folks' - Randy --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Melbourne CFUG Reminder : This Thursday Night
Hi Steve, I'd like to come to the meeting. As I haven't been to the meeting for a while it's my first time to the new location. Is there any parking around and any refreshment (e.g. pizza - I have to plan to come early as I live far away from the city)? Thanks, George 2009/7/21 Steve Onnis st...@cfcentral.com.au Reminding everyone that the Melbourne CFUG is this Thursday night starting at 6:30pm at 21 Victoria Street, Melbourne. Presentation on the night will be a history and overview of the Fusebox web application framework followed by a closer look at the current version (V5.5). We will look at the available resources and tools and how to get started, then take a tour of a sample application. The discussion at the end will encourage comparisons with the other popular CFML frameworks. Form more info please visit http://groups.adobe.com/posts/d1399c4860 Steve --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Melbourne CFUG Reminder : This Thursday Night
George There is parking around the corner and yes there will be pizza and stuff Steve _ From: George Lu [mailto:lug...@gmail.com] Sent: Wednesday, 22 July 2009 12:50 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Melbourne CFUG Reminder : This Thursday Night Hi Steve, I'd like to come to the meeting. As I haven't been to the meeting for a while it's my first time to the new location. Is there any parking around and any refreshment (e.g. pizza - I have to plan to come early as I live far away from the city)? Thanks, George 2009/7/21 Steve Onnis st...@cfcentral.com.au Reminding everyone that the Melbourne CFUG is this Thursday night starting at 6:30pm at 21 Victoria Street, Melbourne. Presentation on the night will be a history and overview of the Fusebox web application framework followed by a closer look at the current version (V5.5). We will look at the available resources and tools and how to get started, then take a tour of a sample application. The discussion at the end will encourage comparisons with the other popular CFML frameworks. Form more info please visit http://groups.adobe.com/posts/d1399c4860 Steve --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Melbourne CFUG Reminder : This Thursday Night
Thank you Steve and Dale. See you there. Cheers, George 2009/7/22 Dale Fraser d...@fraser.id.au There is plenty of parking next door for $4 and onstreet for free around the corner. Location is 21 Victoria Street, Melbourne That is near the corner of Exhibition and Victoria. Not to be confused with 21 Victoria Parade. Regards Dale Fraser http://dale.fraser.id.au http://learncf.com http://flexcf.com *From:* cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] *On Behalf Of *Steve Onnis *Sent:* Wednesday, 22 July 2009 1:15 PM *To:* cfaussie@googlegroups.com *Subject:* [cfaussie] Re: Melbourne CFUG Reminder : This Thursday Night George There is parking around the corner and yes there will be pizza and stuff Steve -- *From:* George Lu [mailto:lug...@gmail.com] *Sent:* Wednesday, 22 July 2009 12:50 PM *To:* cfaussie@googlegroups.com *Subject:* [cfaussie] Re: Melbourne CFUG Reminder : This Thursday Night Hi Steve, I'd like to come to the meeting. As I haven't been to the meeting for a while it's my first time to the new location. Is there any parking around and any refreshment (e.g. pizza - I have to plan to come early as I live far away from the city)? Thanks, George 2009/7/21 Steve Onnis st...@cfcentral.com.au Reminding everyone that the Melbourne CFUG is this Thursday night starting at 6:30pm at 21 Victoria Street, Melbourne. Presentation on the night will be a history and overview of the Fusebox web application framework followed by a closer look at the current version (V5.5). We will look at the available resources and tools and how to get started, then take a tour of a sample application. The discussion at the end will encourage comparisons with the other popular CFML frameworks. Form more info please visit http://groups.adobe.com/posts/d1399c4860 Steve BR --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] OT : Free trial Coldfusion 9 hosting accounts now available
NovaHost is offering free trial Coldfusion 9 hosting accounts while the product is in public beta. I have been given the go ahead from Adobe so if you want an account you can sign up at http://www.coldfusion.com.au. These accounts are not for commercial use and they will be monitored so as to not breach any terms of the beta use policies outlined by Adobe. Again, you can sign up at http://www.coldfusion9.com.au/ Regards Steve Onnis --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: OT : Free trial Coldfusion 9 hosting accounts now available
WOW! this is excellent news Steve, and good on yer for arranging this PPL if you've been keeping up with the CF9 progress and have jumped onto the public beta and have an app that you've proven that works with CF9 and have used some new CF9 features (eg the new spreadsheet or presentation functionality) and you want a platform to advertise how much of a smart cookie you are and beat the competition with a soon-to-market app using CF9 (and ya gotta admit: with a CF9 public beta released, we're probably gonna see the official full release this year) ... then Steve's offer just might be the ticket... On Wed, Jul 22, 2009 at 3:20 PM, Steve Onnisst...@cfcentral.com.au wrote: NovaHost is offering free trial Coldfusion 9 hosting accounts while the product is in public beta. I have been given the go ahead from Adobe so if you want an account you can sign up at http://www.coldfusion.com.au. These accounts are not for commercial use and they will be monitored so as to not breach any terms of the beta use policies outlined by Adobe. Again, you can sign up at http://www.coldfusion9.com.au/ Regards Steve Onnis --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
