Re: [Re: Create a dynamic array]
Hi, Jeffry, Thanks for the response. It is a database table. What I want to do is to make an array dynamically without hard coded 3000 rows in the array for a select drop down. I'll look into the CFLOOP. I'm still new in CF and sometimes do not have a clue where to start. Thanks again, Julia Jeffry Houser [EMAIL PROTECTED] wrote: When you say tables, do you mean HTML tables or database tables? Where are you getting the information from? A Query? Queries are stored in memory as an array of structures. You should be able to display the data using a simple CFOUTPUT or CFLOOP. At 02:49 PM 08/26/2001 -0700, you wrote: Hi, Gurus, I'm having problem with creating an 2-D array dynamically. I have two tables that are updated daily. Hard coded 3000 rows on an array is not a way to display data. Can someone shed some light on how to do it? Can you direct me to any source that cover how to do it? Best Regards, Julia Phu ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:[Re: Create a dynamic array]
Thanks again for the assistance. I want to populate data based on the first select drop down. I tried the AutoPopulate and TwoSelectsRelated from the Allaire Developer site, but I don't know where to place the tag and what else need to be done. Please see below of my code. I'm able to create a dynamic select box, but the text box based on the select box. This is CF4.5.2 on NT. The table and columns are used for testing only. CFQUERY NAME=myquery DATASOURCE=CompanyInfo SELECT passwords.UserID FROM passwords /CFQUERY body User select name=UserPwd cfoutput query=myquery option value=#myquery.UserID# #myquery.UserID# /cfoutput /SELECT input type=Hidden value= name=ID nbsp;nbsp;nbsp;Password input type=Text name=Password /body Jeffry Houser [EMAIL PROTECTED] wrote: I think I understand a little more. Run a CFQUERY to get all the data. This creates a query object in ColdFusion. A query is an array of structures, by definition. Structures are name-value pairs, like an associative array. So, in essence a 2 dimensional array automatically. You can use the query attribute of either CFLOOP or CFOUTPUT to loop over the data and display it. I'm going to assume (uh, oh) that you know the columns that are being returned and will be able to hard-code the column list: CFQUERY name=myquery select * from mytable /CFQUERY TABLE CFOUTPUT query=myquery TR TD#myquery.column1#/TD TD#myquery.column2#/TD TD#myquery.column3#/TD /TR /CFOUTPUT /TABLE That is untested code, but it should give you the general gist of what to do. At 07:05 AM 08/27/2001 -0700, you wrote: Hi, Jeffry, Thanks for the response. It is a database table. What I want to do is to make an array dynamically without hard coded 3000 rows in the array for a select drop down. I'll look into the CFLOOP. I'm still new in CF and sometimes do not have a clue where to start. Thanks again, Julia ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Create a dynamic array
Hi, Gurus, I'm having problem with creating an 2-D array dynamically. I have two tables that are updated daily. Hard coded 3000 rows on an array is not a way to display data. Can someone shed some light on how to do it? Can you direct me to any source that cover how to do it? Best Regards, Julia Phu ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How to dynamically create an array?
Hi, Gurus,
I'm having problem of creating an 2-D array dynamically. I have two tables
that are updated daily. Hard coded 3000 rows on an array is not a way to
display data. Can someone shed some light on how to do it? Is there any
material or document that I can study? I'm still new to ColdFusion and need to
learn as fast as I can to deliver.
Below is a sample code from the Allaire Developer Site. I like to learn how to
make the array dynamically. It's obvious to you that I need to display a group
of subcategories based on the first select box. I might use the
CF_AutoPopulate tag instead of this one. Thanks in advance for your
assistance.
Regards,
Julia
body
form action=TestTwoSelectsRelatedGo.cfm
method=POST
onSubmit=return require_CategoryAndSelection()
name=FormX
script language=JavaScript1.1
var maxlength = 10;
OneA = new Array;
var truelength = OneA.length;
var lst = OneA.length;
function require_Category() {
with (document.FormX.Category) {
RetVal = true;
if (options[selectedIndex] == null) RetVal = false;
else RetVal = !(options[selectedIndex].value
== '');
if (!RetVal) alert('You must choose an option for
Category.');
return RetVal
}
}
function require_Selection() {
with (document.FormX.Selection) {
RetVal = true;
if (options[selectedIndex] == null) RetVal =
false;
else RetVal =
!(options[selectedIndex].value == '');
if (!RetVal) alert('You must choose an option
for Selection.');
return RetVal
}
}
function require_CategoryAndSelection() {
return ((require_Category()) (require_Selection()));
}
function FormXChangeMenu() {
OneA.length = 0;
menuNum = document.FormX.Category.selectedIndex;
if (menuNum == null) return;
if (menuNum == 0) {
NewOpt = new Array;
NewVal = new Array;
NewOpt[0] = new Option(All General Mdse.);
NewOpt[0].value = 'GENALL';
NewOpt[1] = new Option(Arts Crafts);
NewOpt[1].value = 'GENARS';
NewOpt[2] = new Option(Books Publications);
NewOpt[2].value = 'GENBOO';
NewOpt[3] = new Option(For Dollar Stores);
NewOpt[3].value = 'GENDOL';
NewOpt[4] = new Option(Giftware);
NewOpt[4].value = 'GENGIF';
NewOpt[5] = new Option(GM Closeouts/Surplus);
NewOpt[5].value = 'GEN-CL';
NewOpt[6] = new Option(Hardware);
NewOpt[6].value = 'GENHAR';
NewOpt[7] = new Option(Health Beauty Aids);
NewOpt[7].value = 'GENHBA';
NewOpt[8] = new Option(Home Fashion);
NewOpt[8].value = 'GENHOM';
NewOpt[9] = new Option(Housewares);
NewOpt[9].value = 'GENKIT';
NewOpt[10] = new Option(Novelties);
NewOpt[10].value = 'GENNOV';
NewOpt[11] = new Option(Seasonal/Holiday);
NewOpt[11].value = 'GENHOL';
NewOpt[12] = new Option(Sporting Goods);
NewOpt[12].value = 'GENSPO';
NewOpt[13] = new Option(Toys/Games);
NewOpt[13].value = 'GENTOY';
NewOpt[14] = new Option(Adult Merchandise);
NewOpt[14].value = 'GENALT';
NewOpt[15] = new Option(Other);
NewOpt[15].value = 'GENOTH';
}
Re: [Re: CF_TwoSelectsRelated]
duh! It proves my dead brain and inexperience. Forgot about the Server variable. I'll make the change and see what happens. Thank you so much. Julia Bud [EMAIL PROTECTED] wrote: On 8/17/01, Julia Phu penned: I tried to implement the CF_TwoSelectsRelated tag from the Developer's Exchange and got an error of evaluting the expression: MyQuery=Evaluate(Caller.#Attributes.Query#) One problem could be that you've set your attributes.query value to Server.Cats. Server is a variable scope. Inside that evaluate function, not telling what it's doing. :) Try changing it to MyServer.Cats and see what happens. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF_TwoSelectsRelated
Hi, Guru,
I tried to implement the CF_TwoSelectsRelated tag from the Developer's
Exchange and got an error of evaluting the expression:
MyQuery=Evaluate(Caller.#Attributes.Query#)
I have been looking at it too long and lost my brain. Can anyone help to point
out what mistake that I made? Please feel free to make any comment. Your
enlightment is greatly appreicated.
Here is the code straight out from the tag with some modification. Thank you.
cfparam name=Attributes.Query default=Server.Cats
cfparam name=Attributes.Display1 default=MASTER_CAT
cfparam name=Attributes.Display2 default=CAT
cfparam name=Attributes.Value1 default=#Attributes.Display1#
cfparam name=Attributes.Value2 default=#Attributes.Display2#
cfparam name=Attributes.Name1 default=TwoSelectsRelated1
cfparam name=Attributes.Name2 default=TwoSelectsRelated2
cfparam name=Attributes.Size1 default=1
cfparam name=Attributes.Size2 default=1
cfparam name=Attributes.Width1 default=
cfparam name=Attributes.Width2 default=
cfparam name=Attributes.ForceWidth1 default=
cfparam name=Attributes.ForceWidth2 default=
cfparam name=Attributes.ForceWidthChar default=nbsp;
cfparam name=Attributes.EmptyText1 default=
cfparam name=Attributes.EmptyText2 default=
cfparam name=Attributes.Message1 default=You must choose an option for
#Attributes.Name1#.
cfparam name=Attributes.Message2 default=You must choose an option for
#Attributes.Name2#.
cfparam name=Attributes.FormName default=TwoSelected
cfparam name=Attributes.HTMLBetween default=
cfparam name=Attributes.OnChange default=
cfparam name=Attributes.AutoselectFirst default=Yes
cfset FunctionName=ReplaceList(Attributes.FormName, [,], ,)
ChangeMenu()
cfif Attributes.OnChange is Jump!
cfset
Attributes.OnChange=document.location=this.options[selectedIndex}.value;
cfelseif Attributes.OnChange is Submit!
cfset Attributes.OnChange=this.form.submit();
/cfif
!--- use passed query width this code as MyQuery ---
cfset MyQuery=Evaluate(Caller.#Attributes.Query#)
cfquery name=Server.Cats datasource=CompanyInfo dbtype=ODBC
SELECT MASTER_CAT FROM Cats
/cfquery
cfquery name=Server.Cats datasource=CompanyInfo dbtype=ODBC
SELECT CAT FROM Cats
/cfquery
cfoutput
script language=JavaScript1.1
var maxlength=10;
OneA=new Array;
var trueLength=OneA.length;
var lst=OneA.length;
function require_#Attributes.Name1#() {
with (document.#Attributes.FormName#.#Attributes.Name1#) {
RetVal=true;
if (options[selectedIndex]==null) RetVal=false;
else RetVal=!(options[selectedIndex].value=='');
if (!RetVal) alert('#Attributes.Message1#');
return RetVal
}
}
function require_#Attributes.Name2#() {
with (document.#Attributes.FormName#.#Attributes.Name2#) {
RetVal=true;
if (options[selectedIndex]==null) RetVal=false;
else RetVal=!(options[selectedIndex].value=='');
if (!RetVal) alert('#Attributes.Message2#');
return RetVal
}
}
function require_#Attributes.Name1#And#Attributes.Name2#() {
return ((require_#Attributes.Name1#()) (require_#Attributes.Name2#()));
}
function #FunctionName# {
OneA.length=0;
menuNum=document.#Attributes.FormName#.#Attributes.Name1#.selectedIndex;
if (menuNum==null) return;
/cfoutput
cfset Counter=IIF(Attributes.EmptyText1 is not , 1, 0)
cfoutput query=MyQuery group=#Attributes.Display1#
if (menuNum==#Counter#) {
NewOpt=new Array;
NewVal=new Array;
cfset Counter2=IIF(Attributes.EmptyText2 is not , 1, 0)
cfif Attributes.EmptyText2 is not
cfoutput
NewOpt[0]=new Option(#Attributes.EmptyText2#);
NewOpt[0].value='';
/cfoutput
/cfif
cfoutput
NewOpt[#Counter2#]=new Option(#Evaluate(Attributes.Display2)#);
NewOpt[#Counter2#].value='#Evaluate(Attributes.Value2)#';
cfset Counter2=Counter2 + 1
/cfoutput
}
cfset Counter=Counter + 1
/cfoutput
cfoutput
tot=NewOpt.length;
lst=document.#Attributes.FormName#.#Attributes.Name2#.options.length;
for (i=lst; i0; i--) {
document.#Attributes.FormName#.#Attributes.Name2#.options[i]=null;
}
for (i=0; itot; i++) {
document.#Attributes.FormName#.#Attributes.Name2#.options[i]=NewOpt[i];
}
cfif Attributes.AutoSelectFirst is Yes
document.#Attributes.FormName#.#Attributes.Name2#.options0].selected=true;
/cfif
}
/script
/cfoutput
cfif Attributes.Size1 is Auto
cfset Attributes.Size1=Counter
/cfif
cfif Attributes.Size2 is Auto
cfset Attributes.Size2=Attributes.Size1
/cfif
cfoutput
select name=#Attributes.Name1#
onChange=#FunctionName#
size=#Attributes.Size1#
cfif Attributes.Width1 is not
style=width:#Attributes.Width1#
/cfif
/cfoutput
cfif Attriubtes.EmptyText1 is not
cfoutput
option value=
#Attributes.EmptyText1#
/cfoutput
Re: is this list dead? {Michael D.]
It is pretty strange that the messages are not sent consistent. I try my work account and got more mail comparing with this account. Michael, I don't mean to give you pressure, but only want to let you the inconsistence. Thank you. Julia Phu Philip Arnold - ASP [EMAIL PROTECTED] wrote: I'm getting posts, but not as many as we used to get. If I'm right (waits for Michael D to put me straight if I'm wrong) Because of the DNS issues recently, a lot of people (me included) lost all mails from HoF lists - this is beign fixed by the DNS propogation that is happening currently In a message Michael sent to me, the following URL (when re-connected) will explain it; http://www.houseoffusion.com/archive/index.cfm?method=messagecategoryid=9m essageid=40238 Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [RE: [RE: Advices on dynamic SQL, please]]
That's a good plan. I had thought to break the table into two. Thank you for the brain exercise. Julia Mark Warrick [EMAIL PROTECTED] wrote: Setup a table to store the flavor of the month (the category name). Query that table for the value. Then query the original table in the same manner with the value from that query. That's dynamic. ---mark Mark Warrick - Fusioneers.com Email: [EMAIL PROTECTED] Phone: 714-547-5386 http://www.fusioneers.com http://www.warrick.net === -Original Message- From: Julia Phu [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 9:45 PM To: CF-Talk Subject: Re: [RE: Advices on dynamic SQL, please] Hi, Mark, Yes, it was my thought as well. I am trying not to hard code the SQL since the product category, or col2, change monthly. Furthermore, I'm looking for a way to set up a select box to display the 'DISTINCT' col2 since there is more than 30 product category with 300 rows. This is Oracle 8i database. I'm hoping there is a better way for this, so that I can learn from the guru. Regards, Julia Mark Warrick [EMAIL PROTECTED] wrote: How about: select col1, col2, col3, col4 where col2 = 'abc' Or am I missing something here? ---mark Mark Warrick - Fusioneers.com Email: [EMAIL PROTECTED] Phone: 714-547-5386 http://www.fusioneers.com http://www.warrick.net === -Original Message- From: Julia Phu [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 1:30 PM To: CF-Talk Subject: Advices on dynamic SQL, please Hi, guru, I'm seeking your advices for a better solution on dynamic SQL (I guess). Users want to select ABC from a form to view anything under ABC. What is your advices on how to handle it? Table A: col1 col2 col3 col4 aaABC XYdescription1 abABC XYdescription2 acABC XXdescription3 adABC 00description4 aeDEF XYdescription1 afDEF YZdescription2 agDEF 00description3 Your input is greatly appreciated. Julia Phu ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
HTTP/1.0 404 Object Not Found
Hi, guru, Please help on how to resolve the HTTP/1.0 404 Object Not Found error. It is CF 4.5. Thank you. Julia Phu ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [RE: HTTP/1.0 404 Object Not Found]
Thank you all who replied. It was a spelling error on the action page. I had it correct and now have a different error message. It is pretty weird. It had been working until I created a new page for experiment. It now has the ODBC Error Code=37000 (Syntax error or access violation). I again verified the Datasource. It is working. Any suggestion to look into? Costas, the configuration had been set correctly. However, I did double checked to be sure. Thanks for the information. Salute, Julia Phu Costas Piliotis [EMAIL PROTECTED] wrote: First, check to see if the template name is correct... Check internet connection... Check dns server... If you want the index.cfm to appear, you need to add it to the Default Document List. Ensure MIME types are mapped properly in your web server... - Make sure you have for each site an extension mapped. In IIS, go to the site's properties - Home Directory tab - Configuration button - You should have coldfusionroot\bin\iscf.dll mapped to .cfm files. -Original Message- From: Julia Phu [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 11:02 AM To: CF-Talk Subject: HTTP/1.0 404 Object Not Found Hi, guru, Please help on how to resolve the HTTP/1.0 404 Object Not Found error. It is CF 4.5. Thank you. Julia Phu ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Advices on dynamic SQL, please
Hi, guru, I'm seeking your advices for a better solution on dynamic SQL (I guess). Users want to select ABC from a form to view anything under ABC. What is your advices on how to handle it? Table A: col1 col2 col3 col4 aaABC XYdescription1 abABC XYdescription2 acABC XXdescription3 adABC 00description4 aeDEF XYdescription1 afDEF YZdescription2 agDEF 00description3 Your input is greatly appreciated. Julia Phu ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [RE: Advices on dynamic SQL, please]
Hi, Mark, Yes, it was my thought as well. I am trying not to hard code the SQL since the product category, or col2, change monthly. Furthermore, I'm looking for a way to set up a select box to display the 'DISTINCT' col2 since there is more than 30 product category with 300 rows. This is Oracle 8i database. I'm hoping there is a better way for this, so that I can learn from the guru. Regards, Julia Mark Warrick [EMAIL PROTECTED] wrote: How about: select col1, col2, col3, col4 where col2 = 'abc' Or am I missing something here? ---mark Mark Warrick - Fusioneers.com Email: [EMAIL PROTECTED] Phone: 714-547-5386 http://www.fusioneers.com http://www.warrick.net -Original Message- From: Julia Phu [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 1:30 PM To: CF-Talk Subject: Advices on dynamic SQL, please Hi, guru, I'm seeking your advices for a better solution on dynamic SQL (I guess). Users want to select ABC from a form to view anything under ABC. What is your advices on how to handle it? Table A: col1 col2 col3 col4 aaABC XYdescription1 abABC XYdescription2 acABC XXdescription3 adABC 00description4 aeDEF XYdescription1 afDEF YZdescription2 agDEF 00description3 Your input is greatly appreciated. Julia Phu ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [Re: [Re: Automatic File synchronization between clustered servers.]]
Thank you, Jon. Julia Jon Hall [EMAIL PROTECTED] wrote: Windows 2000 File Replication System. It's built into Win2k. http://www.labmice.net/FileMgmt/FRS.htm jon - Original Message - From: Julia Phu [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 11:14 PM Subject: Re: [Re: Automatic File synchronization between clustered servers.] We have a home-grown application to compare files and synchronization from our servers to our business partners' sites. It is written in C++. In term of network connectivity, you can implement using VPN. BTW, what is 'FRS' stand for? Who is the vendor? Where can I look it up? Jon Hall [EMAIL PROTECTED] wrote: How are you handling synchronization now? Win2k FRS does this pretty well, and I haven't run into the problems you are seeing. If you are actually running into network contention on the link between the two servers. You may be able to put another NIC in each machine and specify the content duplication to occur over this new link. If you are talking *nix I dont have a clue... jon - Original Message - From: Bill King [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 12:09 PM Subject: OT: Automatic File synchronization between clustered servers. I have an issue with a client who has a shared server environment and due to the set up of the site and affiliate sites the client requires image files on both server boxes. The problem is that the images that are uploaded often don't copy to both places because of network contention etc. I have been looking for something that will do an automatic file compare and copy to maintain uniformity between two directories. Has anyone run into this and found a solution?? Signed, Bill King HostWorks INC http://www.hostworks.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Native Drivers - Oracle80]]]
Thanks a bunch. It is crystal clear now. [EMAIL PROTECTED] wrote: Remember that each database can have multiple schemas; a schema is really just a set of tables (and indexes, triggers, etc) that belong to a user. But if you've got user A who owns schema B in database XYZ, and your application needs access to the tables in schema B, then you can use user A's userid and password in CF admin for that datasource. You can also, if you like, create another user C and give that user whatever rights are needed to the tables (indexes, etc) in schema A. clear as mud, eh? -Original Message- From: Julia Phu [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 6:09 PM To: CF-Talk Subject: Re: [RE: [Re: Native Drivers - Oracle80]] Thank you so much for your assistance. I finally make it work. One more question if I can. If I create a user A who owns the schema of XYZ database with a password. Should I put user A for CF Login? Please advise. Salute, Julia Phu [EMAIL PROTECTED] wrote: First make sure that you can connect to the database using an Oracle tool like SQLPlus from the console of the CF server. Oracle has its own set of userids and passwords, so you'll have to create (or know) an oracle userid and password. And the service name is what you will put in the host string spot in CF Admin. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [Re: Automatic File synchronization between clustered servers.]
We have a home-grown application to compare files and synchronization from our servers to our business partners' sites. It is written in C++. In term of network connectivity, you can implement using VPN. BTW, what is 'FRS' stand for? Who is the vendor? Where can I look it up? Jon Hall [EMAIL PROTECTED] wrote: How are you handling synchronization now? Win2k FRS does this pretty well, and I haven't run into the problems you are seeing. If you are actually running into network contention on the link between the two servers. You may be able to put another NIC in each machine and specify the content duplication to occur over this new link. If you are talking *nix I dont have a clue... jon - Original Message - From: Bill King [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 12:09 PM Subject: OT: Automatic File synchronization between clustered servers. I have an issue with a client who has a shared server environment and due to the set up of the site and affiliate sites the client requires image files on both server boxes. The problem is that the images that are uploaded often don't copy to both places because of network contention etc. I have been looking for something that will do an automatic file compare and copy to maintain uniformity between two directories. Has anyone run into this and found a solution?? Signed, Bill King HostWorks INC http://www.hostworks.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [RE: [Re: Native Drivers - Oracle80]]
Thank you so much for your assistance. I finally make it work. One more question if I can. If I create a user A who owns the schema of XYZ database with a password. Should I put user A for CF Login? Please advise. Salute, Julia Phu [EMAIL PROTECTED] wrote: First make sure that you can connect to the database using an Oracle tool like SQLPlus from the console of the CF server. Oracle has its own set of userids and passwords, so you'll have to create (or know) an oracle userid and password. And the service name is what you will put in the host string spot in CF Admin. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Native Drivers - Oracle80
Greetings, Does anyone have any suggestion about setting up a DSN with Oracle80 native drivers? Or any sources to lookup? Here is my problem. Oracle8i and CF Application Server 4.5 Enterprise Edition installed on NT 4.0 server with sp6a. When I run the verify, I got the following message. * Are the data soruces setting configured properly? --- I believed I did --- * Did you provide valid security information in the data source settings? --- Honestly, I'm not quite sure what it means. --- * For some databases the ColdFusion Server may need to be logged in under a special NT account rather than the default System Account. Use the Window NT Services Control Panel to change the account the ColdFusion Server service is using. --- Again, I believed I did what it said. --- On the Oracle house, I have one sid with 2 instances. I need a connection to instance2. I'm stumbled on this problem for two days and couldn't find any material or expertise of the failure. Your enlightenment is greatly appreciated. Salute, Julia Phu ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [Re: Native Drivers - Oracle80]
... you must give it a service name remember that because you will have to use this when creating the dsn and you will need rights to the db also Yes, I had Oracle 8 client software installed and have created a service name, ABC. On the CF Settings page: DSN: ABC Host String: 127.0.0.1:1521 ColdFusion Login: ABCowner/** I created ABCowner NT user account with Admin right. What else did I miss? Regards, Julia Phu Tom Davison [EMAIL PROTECTED] wrote: did you install the oracle 8 client software on the server? when you do you must give it a service name remember that because you will have to use this when creating the dsn and you will need rights to the db also. - Original Message - From: Julia Phu [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 10, 2001 4:26 PM Subject: Native Drivers - Oracle80 Greetings, Does anyone have any suggestion about setting up a DSN with Oracle80 native drivers? Or any sources to lookup? Here is my problem. Oracle8i and CF Application Server 4.5 Enterprise Edition installed on NT 4.0 server with sp6a. When I run the verify, I got the following message. * Are the data soruces setting configured properly? --- I believed I did --- * Did you provide valid security information in the data source settings? --- Honestly, I'm not quite sure what it means. --- * For some databases the ColdFusion Server may need to be logged in under a special NT account rather than the default System Account. Use the Window NT Services Control Panel to change the account the ColdFusion Server service is using. --- Again, I believed I did what it said. --- On the Oracle house, I have one sid with 2 instances. I need a connection to instance2. I'm stumbled on this problem for two days and couldn't find any material or expertise of the failure. Your enlightenment is greatly appreciated. Salute, Julia Phu ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [Re: An ignorance question to the masters]
Thank you, Brian. Julia "Brian Thornton" [EMAIL PROTECTED] wrote: I would either create a network share or a ftp directory to somewhere in your root. Use the files in Studio and upload / copy them to the network... - Original Message ----- From: "Julia Phu" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, March 31, 2001 10:06 PM Subject: An ignorance question to the masters Hi, I'm new to ColdFusion and yet have a stupid question. I have a development server which has IIS, Oracle8i, and CF Application Server installed. The CF Studio is installed on my laptop. My ignorance is how to do my work from my laptop and connect to the development server. Is this the right setup? Thanks in advance. Julia ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [Re: An ignorance question to the masters]]
Thank you all for your enlightement. Raymond's suggestion is a better solution for my situation. I'm developing a web application using Oracle 8i as a back end database. My concern is the ODBC from my laptop to the development server. I'm still learning. Julia "Raymond B." [EMAIL PROTECTED] wrote: As it's your dev server I'd enable RDS and work through that. That way you can use Studio's full debugging, as well as having direct read/write to the files, the database view as reference, and quick preview w/in studio. RDS uses port 80 so there should be no firewall issues to worry about it. For easier db stuff you might want to telnet right into Oracle or grab some client tools. -Original Message----- From: Julia Phu [mailto:[EMAIL PROTECTED]] Sent: April 1, 2001 13:35 To: CF-Talk Subject: Re: [Re: An ignorance question to the masters] Thank you, Brian. Julia "Brian Thornton" [EMAIL PROTECTED] wrote: I would either create a network share or a ftp directory to somewhere in your root. Use the files in Studio and upload / copy them to the network... - Original Message ----- From: "Julia Phu" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, March 31, 2001 10:06 PM Subject: An ignorance question to the masters Hi, I'm new to ColdFusion and yet have a stupid question. I have a development server which has IIS, Oracle8i, and CF Application Server installed. The CF Studio is installed on my laptop. My ignorance is how to do my work from my laptop and connect to the development server. Is this the right setup? Thanks in advance. Julia ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
An ignorance question to the masters
Hi, I'm new to ColdFusion and yet have a stupid question. I have a development server which has IIS, Oracle8i, and CF Application Server installed. The CF Studio is installed on my laptop. My ignorance is how to do my work from my laptop and connect to the development server. Is this the right setup? Thanks in advance. Julia ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
