When I want to save a longblob in mysql via nhibernate the app hangs. when nhibernate is going to save the object to the database, shows the sql, but when I going to see it on the console it writes the sql until the app hangs. Any ideas? Regards ...
In the past, when I implemented my own authentication mechanisms I would have a user table with relationships to other tables in my application's MySQL database. However, now that I'm considering using ActiveDirectoryMembershipProvider, I see no way to create similar relationships between AD users and those tables. What's the normal wa...
Hi all, I recently switched from Apache DBCP connection pooling to C3P0 and have gone through my logs to see that there are connection timeout issues. I haven't had this in the past with DBCP and Tomcat, so I'm wondering if it is a configuration issue or driver issue. Whenever I load a page after the server has been idle for a while, ...
I have this database: Tab1 ---1:n--->tab2 (parent->id) (max1:4) - the complicated part Tab1 ---1:n--->tab3 (parent->id) - simple join tab1 id name version ..etc. tab2 id parent type price ..etc. tab3 id parent type data I'd like to select complete set of information from these 3 joined tables, but I need to use many v...
I want to count some rows in my database and I'm using the following code: $tagname = Person; $query = "SELECT COUNT(thread_tag_map.tag_id) AS tagcount FROM tags, thread_tag_map WHERE thread_tag_map.tag_id = tags.id AND tags.name = '$...
I have php scripts that I have to run on linux as well as on Windows servers. I want to use the same scripts without doing any modifications for those 2 environments. Theses scripts will be scheduled with cron (on linux) and with the windows scheduler (or other, I don't care for now) for my Windows environment. However, some of theses ...
while($tag = mysqli_fetch_assoc($result)) { $arrayresult[$tag['id']][$tag['name']] = $tag['count']; } the $result contains 4 rows from database table. i want it to be like: $arrayresult[1]['mac'] = 34 $arrayresult[22]['pc'] = 32 $arrayresult[31]['windows'] = 14 $arrayresult[4]['linux'] = 23 the code above doesnt seems to work...
Hi all, My question is how to get the next id using NHibernate in a mysql db for an auto-increment ID column ? Thanks, ...
I'm using a system where the dates are stored as strings in the format dd/mm/yyyy. Is it possible to convert this to yyyy-mm-dd in a SELECT query (so that I can use DATE_FORMAT on it)? Does MySQL have a date parsing function? Currently the only method I can think of is to concatenate a bunch of substrings, but hopefully there's a simple...
Could anyone explain what node means in MySQL? This one is talking about nested set. I am reading a document from Codeigniter's wiki and I am not sure what I am supposed to add for $node. getSubTreeAsHTML (line 704) Renders the fields for each node starting at the given node * return: Sample HTML render of tree string getSubTre...
Hello, My problem is the following Y have two functions that are called from inside a function(method) If the outcome of the first function is TRUE, the second function runs a select and an update query. The second function runs a select with the query($sql) command The update query uses: $stmt = $db->prepare($sql); $stmt->execut...
I'm looking for a GUI tool that requires minimal configuration which will enable an end-user (read cheap help) to add/delete/change MySQL table entries. I don't want a tool that is a MySQL manager, configurator, administrator, etc. Just a simple front-end to display and manipulate data in a table. What suggestions do you have? I've lo...
Does anyone know a PHP extension to use mod_dbd for database connections? Our application needs to access a remote database. It used to be an Apache module using mod_dbd for database connections and the transaction takes about 200ms. Now we changed the application to PHP and the same transaction takes over 600ms now. We hope some kind o...
Hi guys and girls, I am attempting to upload a .pdf file into a mysql database using php. It is all good except for the contents of the file. No matter how I seem try to escape special characters, the query always fails, mostly with "Unknown Command \n". I have used addslashes, mysql_real_escape_string, removeslashes etc. Does anyone...
I have many timestamp columns that I need to use with mixed timezones. The users timezone is set in the language I'm using for the front-end so I need MySQL to return a unix timestamp from a select *. Is there a way to turn off the auto formatting when fetching data from MySQL timestamp columns? ...
I have a table that stores "records" and already has primary key. Table A ======= id (INT) PK auto_increments project_id (INT) record_text (TEXT) This table stores "records" for all of my projects. It is desirable to have a secondary key that auto increments for the projects. Example: If project 1 had id's of (1,5,8,9). It would...
I have table in mysql database which have field with datatype is datetime. I want to save the datetime in this minute, for this I use " Now() ", but it does not work, It just save 000000000000 in databaes. ...
NOTE: Apparently, the reason the MySQL connector installation doesn't show up automatically in the Dialog Boxes for adding a data source is because the Visual 2008 Express Edition doesn't allow "3rd party integration" within the Visual Studio IDE. So, this makes setting up the data source manually even more important because the integrat...
Here's a simplified example of what I'm talking about: Table: students exam_results _____________ ____________________________________ | id | name | | id | student_id | score | date | |----+------| |----+------------+-------+--------| | 1 | Jim | | 1 | 1 | 73 | 8/1/09 | | 2 | Joe | ...
I'm planning an application that allow users to create a specific type of website. I wanted to link account names to 'account.myapp.com'. Going to 'account.myapp.com' will serve up a website. I haven't a clue on how to map this. I'll be using Code Igniter as my development tool. I would like to give users the ability to add a registered...