[cfaussie] Re: ot: db architecture question
ok thanks guys - i resent the impilication it's a dailywtf though scott! anyway, you've basically clarified the issue for me. I am now armed to go back to my boss and say, we can do it this way... as for passing in parameters, yes you can query against a view with parameters (as per dale's example above), but you can't actually call a view like you do with a stored proc where you actually *pass* the parameters to the proc. that's all i meant. it may seem a little stupid (why not just use stored procs) but it all comes down to linked views - you can't link stored procs from one server to another, but you can with views. we have a view on the secure server that gets all data relevant to my site, and that view is linked to a view on a non secure server that cf has access to. the cf query pares back the initial dataset with parameters, but what i am after is an abstracted way to query the secure db with those parameters initally. did that make sense? it looks a little like this: secure sql server view (which is linked to the non-secure server): SELECT * FROM db1.tblclients ...which returns a huge resultset. non-secure sql server view: SELECT * FROM db1.the_secure_view_above and the coldfusion query: SELECT * FROM db2.the_non_secure_view_above WHERE clientid = '666' and ultimately what i'd like to be doing in CF is: SELECT * FROM db1.the_secure_view_above WHERE clientid = '666' but unfortunately the ppl in control here don't want me accessing db1(secure) directly. which let me to the initial question. and this following clarifaction. anyway, whatever, we'll get it sorted. i'm off to get my dose of thedailywtf.. --~--~-~--~~~---~--~~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Running CF on Apache and IIS
Jeremy, you can try vmware.com they have a virtual workstation for dev's, that can allow you to run any combo of things...just set it in it's own sandbox and you're away...eg. I read (can't remember where), but this guy set up many different combos on his server to replicate his clients machine..CFMX with Apache, LAMP, etc... CarlOn 6/30/06, cfgroupie [EMAIL PROTECTED] wrote: Hi Guys,I know that you can't run both Apache and IIS together at the sametime(unless different ports) but I'm running cf multi-server and I wantto have the ability to turn off IIS and turn on Apache and visa-versa is there a way you can do this in CF? Have two servers configured butonly run one at a time?Or am I too pie in the sky.Jeremy-- Postal: Po Box 3462 Dural, NSW 2158Email: mailto:[EMAIL PROTECTED] Skype: skype:carlos-amigos?call --~--~-~--~~~---~--~~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: creating .doc files in Coldfusion
Using COM does require a licensed copy of Office on the server. However, even Microsoft doesn't recommend using Office on the server! http://support.microsoft.com/kb/257757/en/ In a past life I used COM extensively with CF5 and it was very unreliable and quite slow. I can't imagine it would be any better using CFMX given its now Java rather than C++. I've used POI for generating and reading Excel files. It's relatively simple and it works a treat (just make sure you use javaCast for int values). However I have not used it for generating Word docs so can't comment in that regards. If it were me, I'd be trying POI or Jasper (Jasper uses POI for generating its Excel and Word docs). --~--~-~--~~~---~--~~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Running CF on Apache and IIS
On 6/30/06, cfgroupie [EMAIL PROTECTED] wrote: Hi Guys,I know that you can't run both Apache and IIS together at the sametime(unless different ports) but I'm running cf multi-server and I wantto have the ability to turn off IIS and turn on Apache and visa-versa is there a way you can do this in CF? Have two servers configured butonly run one at a time?Hi Jeremy, On your first point: you could have two different IP addresses then bind Apache to one and IIS to the other. Otherwise, set both Apache IIS to run on port 80, and write a couple of batch files to control them: apache.bat: net stop World Wide Web Publishing net start Apache2 iis.bat: net stop Apache2 net start World Wide Web Publishingand make sure you set one of the services to manual startup.This works fine on my WinXP machine, you may need to tweak it to match your service names -- Lindsay Evanshttp://lindsayevans.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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: ot: db architecture question
To my understanding. (Please someone point out to me if they know of any special magic that SQL linked servers can do that other SQL Clients cannot)Using a 2nd SQL server instance with linked views to a 1st sql server is no more secure than having a data source directly to the 1st server. In terms of the 1st (the secure) SQL instance - its data is being queried under a given user account that the 2nd instance has been given say (non_secure_user)so when im configuring my secure server im giving select only permissions to views X, Y, Z to non_secure_user So as far as the 1st server is concerned if its another linked server or Coldfusion conneting via JDBC its just another client.I know *some* sysadmins are a bit thick (someone does a 6 week mcse course and they think they know everything) , but hopefully they can understand this logic and just let you query the DB directly. PatOn 7/6/06, grant [EMAIL PROTECTED] wrote: ok thanks guys - i resent the impilication it's a dailywtf though scott!anyway, you've basically clarified the issue for me. I am now armed togo back to my boss and say, we can do it this way...as for passing in parameters, yes you can query against a view with parameters (as per dale's example above), but you can't actually calla view like you do with a stored proc where you actually *pass* theparameters to the proc. that's all i meant.it may seem a little stupid (why not just use stored procs) but it all comes down to linked views - you can't link stored procs from oneserver to another, but you can with views. we have a view on thesecure server that gets all data relevant to my site, and that view islinked to a view on a non secure server that cf has access to. the cf query pares back the initial dataset with parameters, but what i amafter is an abstracted way to query the secure db with thoseparameters initally. did that make sense?it looks a little like this: secure sql server view (which is linked to the non-secure server):SELECT *FROM db1.tblclients...which returns a huge resultset.non-secure sql server view:SELECT *FROM db1.the_secure_view_above and the coldfusion query:SELECT *FROM db2.the_non_secure_view_aboveWHERE clientid = '666'and ultimately what i'd like to be doing in CF is:SELECT *FROM db1.the_secure_view_aboveWHERE clientid = '666' but unfortunately the ppl in control here don't want me accessingdb1(secure) directly. which let me to the initial question. and thisfollowing clarifaction.anyway, whatever, we'll get it sorted. i'm off to get my dose of thedailywtf.. --~--~-~--~~~---~--~~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: ot: db architecture question
Interesting problem. No technical answers here, but a question to help clarify... By secure, do you mean confidentiality of the data or stability of the information? If it is confidentiality, then the security is tossed as soon as you extract the data into the view, regardless of where it came from. Stability can be addressed on 2 fronts: a) Address the perception that simply querying the data can impact stability. Correct me if I am wrong, but this seems to be more a factor of the efficiency of the querying tool than the SQL data itself. b) Develop a middle-ware solution. If confidentiality is an issue, then that will need to be considered. I developed a solution where information from .dbf files were extracted on a regular basis in XML format based on last update and inserted into a seperate SQL DB every 15 minutes or so, as even looking at dbf files can stuff them up due to date formats and record locking protocols. I could then query my SQL to my heart's content. Be interested in hearing what you come up with. Chad On 7/6/06, grant [EMAIL PROTECTED] wrote: ok thanks guys - i resent the impilication it's a dailywtf though scott! anyway, you've basically clarified the issue for me. I am now armed to go back to my boss and say, we can do it this way... as for passing in parameters, yes you can query against a view with parameters (as per dale's example above), but you can't actually call a view like you do with a stored proc where you actually *pass* the parameters to the proc. that's all i meant. it may seem a little stupid (why not just use stored procs) but it all comes down to linked views - you can't link stored procs from one server to another, but you can with views. we have a view on the secure server that gets all data relevant to my site, and that view is linked to a view on a non secure server that cf has access to. the cf query pares back the initial dataset with parameters, but what i am after is an abstracted way to query the secure db with those parameters initally. did that make sense? it looks a little like this: secure sql server view (which is linked to the non-secure server): SELECT * FROM db1.tblclients ...which returns a huge resultset. non-secure sql server view: SELECT * FROM db1.the_secure_view_above and the coldfusion query: SELECT * FROM db2.the_non_secure_view_above WHERE clientid = '666' and ultimately what i'd like to be doing in CF is: SELECT * FROM db1.the_secure_view_above WHERE clientid = '666' but unfortunately the ppl in control here don't want me accessing db1(secure) directly. which let me to the initial question. and this following clarifaction. anyway, whatever, we'll get it sorted. i'm off to get my dose of thedailywtf.. --~--~-~--~~~---~--~~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Running CF on Apache and IIS
Thanks guys, I use VMWare occasionaly. So I know what you mean there. I hadn't thought of different IP addresses but on an XP machine not sure if thats the case. thanks will look into it. Jeremy --~--~-~--~~~---~--~~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
