http://guruza.com/searches/show/1019 Questions recently submitted to Guruza that match the query: database Wed, 20 Aug 2008 08:26:19 -0700 http://guruza.com/question/551/reward-0.00 I tried hard to find a free host on which Blab Lite Chat script whose details are given below could be installed and run. As per Instructions I create Database and put username , password and database name in config.php file , I upload the file to website, Give 777 Chmod to entire directory then when i run install.php i get a blank page. I tried with two hosts http://00bp.com, http://1gb.in. Blab Lite Chat Script Desription : http://www.hotscripts.com/Detailed/17476.html Download : http://www.hotscripts.com/jump.php?listing_id=1747... Please guide me Im new to PHP. Wed, 22 Aug 2007 00:40:38 -0700 http://guruza.com/question/483/reward-1.00 Ruby / Ruby on Rails: I am building a database wrapper in a class. I want to expose a string array of people (ex: ['john','jane','lucie']) which basically wraps a comma-delimited string column in a legacy database (names are in the db as: 'john,jane,lucie'). I'd like to be able to do: foo.people[1] = 'mark', foo.people.pop or even foo.people.push('richard') and have the changes reflected in the database. How do I hook into an array to be able to perform the underlying database operations? I'm not quite sure how to implement this correctly. Mon, 15 Jan 2007 10:40:57 -0800 http://guruza.com/question/482/reward-0.00 I am trying to use sqlite3 for my dev database with my Rails app (1.2rc2). I am on OS X so sqlite3 is installed by default (I even installed the lastest version with darwinport), and I have done gem install sqlite3-ruby. However, when I try to do anything that has to do with ActiveRecord, I get errors. Here's an example: >> Domain.new ActiveRecord::StatementInvalid: ActiveRecord::StatementInvalid from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4.5848/lib/active_record/connection_adapters/sqlite_adapter.rb:273:in `table_structure' from /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.3.1.5848/lib/active_support/core_ext/object/misc.rb:23:in `returning' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4.5848/lib/active_record/connection_adapters/sqlite_adapter.rb:272:in `table_structure' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4.5848/lib/active_record/connection_adapters/sqlite_adapter.rb:210:in `columns' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4.5848/lib/active_record/base.rb:760:in `columns' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4.5848/lib/active_record/base.rb:2048:in `attributes_from_column_definition_without_lock' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4.5848/lib/active_record/locking/optimistic.rb:45:in `attributes_from_column_definition' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4.5848/lib/active_record/base.rb:1490:in `initialize_without_callbacks' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4.5848/lib/active_record/callbacks.rb:225:in `initialize' from (irb):1 Any idea? EDIT: The funny thing is that I use sqlite3 and it works great with another project I started some time ago... Mon, 15 Jan 2007 07:58:30 -0800 http://guruza.com/question/437/reward-5.00 I'm a newbie to RoR's and I'm having fun with it. My question has to do with how to configure a RoR CMS that allows users to publish pages from the CMS to their hosted domain. I want users to be able to login to the CMS to enter their site content. When they create/update information for their site, their domain should be updated as well. NOTE: All users will share the same db tables for storing their information. Originally, I wanted to create static pages in the users domain directory because their pages wouldn't change that often. The static pages would be cached and changed when updated. Now I'm wondering if I should allow users sites to be dynamically generated. I'm not sure which approach would be better or easier to implement. I need to know how to setup or configure my CMS that allows a user to publish to their domain if I decide to publish flat pages to their domain. If I take the dynamic approach, I need to understand how to configure a users domain so that it logs into the database for th user and use their date and the templates that have selected for their web site. Although I'm new to RoR, I'm not new to programming and understand a little bit about servers. It's okay if you get technical. Tue, 31 Oct 2006 20:07:07 -0800 http://guruza.com/question/435/reward-5.00 What is the best automated way to keep a hosted MS SQL server in sync with another hosted SQL server at a different web host? My host doesn't support replication (e.g. publishing). I'm primarily interested in doing this to allow me to failover to another server at another host if our site goes down. Sat, 28 Oct 2006 10:51:48 -0700 http://guruza.com/question/418/reward-25.00 In a RoR application I am making I have a sortable table made using a technique similar to this: http://dev.nozav.org/rails_ajax_table.html This is a two part question: Normally the table is 'unsorted' when you get to it even though the items are alreay in alphabetical order according to the first column. Because of this, the first time you click title to sort by name it appears to do nothing because it was going from 'unsorted' to 'sorted by name' and both are identical. On the first click it should go from 'sorted by name' to 'reverse sorted by name' and the sort_td_class_helper should have the 'sortdown' class applied to it when the page loads. **A solution would either include sample code or enough explanation that I can get it to work.** The other part of the question is how can I make the sorting case-insensive? **A solution would either include sample code or enough explanation that I can get it to work.** Thu, 21 Sep 2006 10:55:10 -0700 http://guruza.com/question/408/reward-5.00 I want to save ruby code inside a database, retrieve it and execute it. Is it possible to execute a string returned by the database as ruby code? Thu, 14 Sep 2006 17:33:54 -0700 http://guruza.com/question/368/reward-0.00 I am new to ruby on rails and doing a simple application as I am studying ruby on rails. I have a m:n relationship between people and languages ... a person can know many langs and a lang can be known by many people ... I want to give a GUI in which there are 2 lists of languages for a person to edit 1 with the languages he knows 2 other languages .. I want to allow him to add & remove languages ie shift from one list to the other list Eg: if person1 has english and french in the database , the lists would look like List1: english french List2: spanish italian german etc etc etc... [ plz note: they are side by side ] and he can double click or do something to select a lang in list2 and add it to list1 and vice versa... I thought it would be a good excerise to learn ruby but I am struck .. I wanted to know if there is any helper class available for this kinda feature... Can someone suggest me as to how I can do this efficiently in ruby.. [ I currently have a string which has all languages seperated by comma and the user can modify the string.. I parse the string @ the controller and store it into the database.. ] Thu, 31 Aug 2006 21:12:38 -0700 http://guruza.com/question/363/reward-0.00 I am new to ruby on rails and am writing a simple database application... I have people table and languages table... they have m:n relationship using languages_people table [ has_and_belongs_to_many ] now i was able to access all langs for a person using just person1.languages [ array of language] i have displayed it to front end ... which will be edited and sent back to the controller... here i need to update the languages of that person.... i dont know how to do it... i tried to delete all previous languages and then addnew all of them ... but was not able to... as i am very new to this framework, i dont have a clue as to what to do... After reading the features offered by ruby on rails I am very much sure that there is a simple and easy way to do this .... can anyone help me.... giving me the syntax to delete all languages corresponding to a person , and adding languages into it will be great... [ if there is a better method plz let me know..] when i tried to add them using [ here i have copied all langs from frontend to temp_langs] for lang in temp_langs @person.languages << Language.new( :name => lang ) end it created new enteries in languages table and then added into relation... which is not what i want... i dont want to add a new entry into languages table ... i want to add an entry only in the languages_people table plz... awaiting your response... Wed, 30 Aug 2006 21:16:47 -0700 http://guruza.com/question/323/reward-3.00 how to get validates_presence_of to work with non-null float/boolean/integer fields? Has anyone figured out a way to get validates_presence_of to work with float, boolean, and integer fields that are defined as non-null in the schema? The problem is, rails intializes these types to the default schema value, which for mysql is never null if the column is not allowed to be null, and as a result they are initialized in the form with a value, and are never null. I found a work around for integers that requires a nasty method override in the ActiveRecord class that sets the default values from the database, but I can not find a solution to do the same for floats because ruby will not let me assign a float to null once it has been initialized with a value. Wed, 16 Aug 2006 16:33:19 -0700 http://guruza.com/question/317/reward-0.00 Hi, Rails causes WEBrick to GET 2 diff locations: AWDWR Chpt 6 strange results: First browser call to /Admin shows correct form; - And WEBrick reports: "Get /admin HTTP/1.1" 200 485 - -> /admin Subsequent browser calls to /Admin show: NoMethodError in AdminController#index undefined method `each' for # - And WEBrick reports: "Get /admin HTTP/1.1" 500 10767 - -> /admin First browser call to /Admin/new shows correct form for editing; - And WEBrick reports: "Get /admin/new HTTP/1.1" 200 10767 - -> /admin/new Subsequent browswer calls to /Admin/new show: NoMethodError in AdminController#new undefined method `each' for # RAILS_ROOT: ./script/../config/.. - And WEBrick reports: "Get /admin/new HTTP/1.1" 500 9798 - -> /admin/new So the first calls produce a "Get...200..." and the right browser results. Subsequent calls produce a "Get...500..." and "NoMethodError" Thanks for your help, Joe Mon, 14 Aug 2006 15:39:23 -0700 http://guruza.com/question/279/reward-10.00 I have a rails app that runs an nmap scan on a host and reports the response via ajax. I use backtick to run nmap via my controller. What I've noticed is that if the nmap scan takes a while (say about 2 minutes), rails will block all request until the shell command finishes executing. My question is if there is a more effecient way to run shell commands via rails? Will I have to thread the nmap scan so the rails controller doesn't block until it receives a response? Thu, 27 Jul 2006 12:04:06 -0700 http://guruza.com/question/185/reward-5.00 I wanted to know the technical details of how an online air ticketing/ hotel booking site works (expedi.com or hotels.com or orbitz.com, etc.)? The specific question is how online site brings the result when someone make search for ticket booking? Does online site has access to airlines and hotel's database? So that whenever someone make search online then that site connects to all participating airlines or hotels database and query them and after that do mining on those data and show it to end user? And when user purchases any ticket then how airlines or hotels database gets updated? Sat, 01 Jul 2006 14:11:01 -0700 http://guruza.com/question/167/reward-5.00 What support does ruby have for internationalization? I have heard that ruby on rails doesn't support a large amount of character sets. I am in the midst of rolling out a international application and need to ofcourse make sure that rails can support every character set possible. Some I need initially are UTF8, Big 5, Shift JIS. Can rails handle this? Fri, 30 Jun 2006 07:19:54 -0700 http://guruza.com/question/132/reward-20.00 What do you think are the top 5 services like this (ask an expert, dough involved) not including Goog and Yahoo? Thu, 29 Jun 2006 12:54:08 -0700 http://guruza.com/question/117/reward-0.00 webapp dev with rails Mon, 26 Jun 2006 09:10:12 -0700 http://guruza.com/question/106/reward-5.00 Where can I find the full version of "Perhaps, perhaps, perhaps" by Mari Wilson? Wed, 14 Jun 2006 16:26:53 -0700 http://guruza.com/question/102/reward-20.00 how do I get imap working on OSX Server 10.4 - I'm getting a password not accepted error from the mail client when I try to connect. Tue, 13 Jun 2006 23:12:42 -0700 http://guruza.com/question/93/reward-10.00 Can I use Ajax to request a controller/script multiple times and simulate multiple threads? Fri, 09 Jun 2006 13:42:18 -0700 http://guruza.com/question/82/reward-10.00 I am interested in using Java for a small web project. Here are the essential details of the project: I expect to get light to moderate traffic. The site will be more of an application than a content site. I would like to use an MVC framework. My models will be backed by a database. I will pay $10 to someone that will discuss the various components I should consider using. I expect the discussion will take around ten minutes. Tue, 06 Jun 2006 18:36:29 -0700