Search Results

Search found 20931 results on 838 pages for 'mysql insert'.

Page 612/838 | < Previous Page | 608 609 610 611 612 613 614 615 616 617 618 619  | Next Page >

• Regex to match anything (including the empty string) except a specific given string.

  - by dreeves

  I'd like to test whether a string contains "Kansas" followed by anything other than " State". Examples: "I am from Kansas" true "Kansas State is great" false "Kansas is a state" true "Kansas Kansas State" true "KansasState" true (For my immediate purposes this should work with mysql's REGEXP but if there's a more elegant way using PCRE, I'd like to see that too.)

  Read the article

• “Function” calling inside store procedure

  - by idimba

  Hi, I have a big store procedure, that contains a lot of INSERTs. There're many INSERTS that almost identical - they're different by some parameter(s) (all INSERTs to the same table) Is there a way to create a function/method, to which I'll pass the above parameter(s) and the function/method will generate concrete INSERT's? Thanks

  Read the article

• How do can I have a dropdown list(select HTML) where i want to have one of the options where i allow

  - by Mo

  Hi I want to have a drop down menu where a user can select from several predefined options but i also want to give him the option of inserting a user specific value, i was thinking having one of the options as "user specific" which will in turn allow the user to insert a user specif entry in a text box that appears or is editable when user selects the "user specific" option. any one have any ideas how i can implement this is HTML and Javascript? thank you

  Read the article

• How to login users that are stored within a Wordpress account

  - by user3716795

  I am developing an iOS app that is password protected and all the users are stored in a wordpress account that, of course, is password protected as well. Does anybody know the format that wordpress uses to store login information for these accounts, I would assume that it is a MySQL that sends a json? I have only been able to find the database code for the initial admin page but nothing that shows the way these accounts (815 to be exact) would be stored within the site.

  Read the article

• asp.net datasource in memory which component suites this better?

  - by Mike

  I need to create a page that has a listbox with databound items. Upon clicking an entry in the listbox, the page will postback and insert an entry into a listview. The listview should have the item's name, and a textbox allowing the user to edit the value for each. I don't want the listview to be in "edit" mode. I just want the user to be able to update the value. Is this possible?

  Read the article

• how can i get $(document).height() NEW value when new data has been added?

  - by andufo

  Lets suppose that $(document).height() is 1000. Then i insert a new div at the bottom of the page with height=100. The $(document).height() should be 1100 but it keeps throwing 1000 to me. How can i get the new $(document).height() dynamically? Thank!

  Read the article

• WTF why does this SQL work in VS but not in CODE?

  - by acidzombie24

  The line cmd.ExecuteNonQuery(); cmd.CommandText CREATE TRIGGER subscription_trig_0 ON subscription AFTER INSERT AS UPDATE user_data SET msg_count=msg_count+1 FROM user_data JOIN INSERTED ON user_data.id = INSERTED.recipient; The exception: Incorrect syntax near the keyword 'TRIGGER'. Then using VS 2010, connected to the very same file (a mdf file) i run the query above and i get a success message. WTF!

  Read the article

• How to run jQuery onClick? Need to pass a variable to run .ajax

  - by user205307

  I'm trying to run .ajax and insert a data element from the onClick of an item from the page. Whats the best way to do this? Something like this: function grabinfo(foo){ $.ajax({ url: "infospitter", method: "GET", data: "id="+foo, success: function(html){ $(#showstuff).html(html); } }); } <input onClick="javascript:grabinfo(18343)" /> // and on page each item will have this button input

  Read the article

• Automatically generating Guids in Sybase

  - by Daniel Dyson

  I have a table with 42 million records. 32 million have a null value and I would like to generate a new guid for each one. Should I do this in batches? Also, going forward, I would like a new guid added to the field on the insert of a new record. What is the best way to do this? The field is not the primary key, which is an auto-incrementing integer.

  Read the article

• Getting the image URL without the HTML in Rails

  - by tesmar

  Hi, In Rails is there a way to get the URL to the image (going through the assets_host) and just return the URL of the image? I want to use assets_host data in my Javascript, but I just need to insert the URL into the JS, not the whole image_tag. Thank you in advance!

  Read the article

• How to save SMS to inbox in android programmatically and how to reqeust the correct permissions?

  - by Verena

  Found this question while trying to do the same: http://stackoverflow.com/questions/642076/how-to-save-sms-to-inbox-in-android-programmatically. But this part: getContentResolver().insert(Uri.parse("content://sms/sent"), values); throws an SecurityException. I requestet SMS_WRITE permission in the manifest file. Thanks in advance!

  Read the article

• issue with Cayenne Entity Manager

  - by user224270

  Hi, I'm trying to persist an object into the database using Cayenne Entity Manager. And unfortunately I get the following error: org.apache.cayenne.CayenneRuntimeException: [v.3.0 Apr 26 2010 09:59:17] Commit Exception Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'myDatabase.auto_pk_support' doesn't exist Any idea how i could solve this issue? Thanks.

  Read the article

• How do I error handle the FTP functions in PHP.

  - by Itay Moav

  When connecting to mysql, I have functions to get the relevant error message and error code, I see nothing of the sort in the list of ftp functions of PHP. Is there a best practice to handle errors in FTP?

  Read the article

• TinyMCE empty link popup

  - by silent1mezzo

  When I try to insert a link using the TinyMCE link plugin all that happens is I get an empty popup box. It continuously tries to load: tiny_mce/utils/mctabs.js tiny_mce/utils/form_utils.js tiny_mce/utils/validate.js tiny_mce/themes/advanced/js/link.js I've seen solutions where you need to edit a config.php file, but I only have the JS version of TinyMCE

  Read the article

• PHP script sample for iPhone hi-score/survey uploading?

  - by Horace Ho

  I am looking for a PHP example/tutorial which can accept hi-scores/survey upload from an iPhone. Hopefully, the PHP script: accepts POST, in additional to GET works over SSL (https) connects to MySQL In addition, it'd best the iPhone can get a session from the server and submit the session value along with the hi-score. Thanks

  Read the article

• Can Doctrine 1.2 handle custom data type like geometry data type?

  - by Carson

  I want to create tables that contain geometry data types (Mysql spatial extension). which steps are needed to map these with Doctrine 1.2? Any idea how is the codes of yaml mapping and corresponding modal class for custom data mapping with Doctrine 1.2? Thanks.

  Read the article

• MSSQL + Copy data from one server database table to the other

  - by lucky

  Hello All, I dont know how to copy table data from one server - database - table TO other sever - database - table. If it is with in the same server and different databases, i have used the following SELECT * INTO DB1..TBL1 FROM DB2..TBL1 (to copy with table structure and data) INSERT INTO DB1..TBL1(F1, F2) SELECT F1, F2 FROM DB2..TBL1 (copy only data) Now my question is copy the data from SERVER1 -- DB1-- TBL1 to SERVER2 -- DB2 --TBL2 Thanks in advance!

  Read the article

• How does a database handle auto-number field if it's limit is reached?

  - by Nitesh Panchal

  Hello, In my tables, i have selected id column to be of type int (4 bytes). The answer i want to know is how will any database handle it once it's limits are reached? Will the database refuse to insert any more records in table? or what exactly will happen? Also how should i tackle this type of problem (if the database doesn't handle it by itself)?

  Read the article

• C# - Inserting and Removing from Cache

  - by Nir

  1 - If I insert to Cache by assigning the value: Cache["key"] = value; what's the expiration time? 2 - Removing the same value from Cache: I want to check if the value is in Cache by if(Cache["key"]!=null), is it better to remove it from Cache by Cache.Remove("key") or Cache["key"]=null ?

  Read the article

• Supporting twitter-like user page urls with apache/php?

  - by user246114

  Hi, I'm using php on apache with mysql. I want to let users enter a url into their browser to see a custom user page for themselves, just like twitter does. For example, they could enter urls like: www.mysite.com/johndoe www.mysite.com/janedoe and see that user's page. How could I do this with php and apache? I don't want to create a folder on disk for every user like above, I'd instead kind of like to catch the url and generate the page on the fly for them, Thanks

  Read the article

• Manipulating values from database table with php

  - by charliecodex23

  I currently have 5 tables in MySQL database. Some of them share foreign keys and are interdependent of each other. I am displaying classes accordingly to their majors. Each class is taught during the fall, spring or all_year. In my database I have a table named semester which has an id, year, and semester fields. The semester field in particular is a tinyint that has three values 0, 1, 2. This signifies the fall, spring or all_year. When I display the query instead of having it show 0 or 1 or 2 can I have it show fall, spring etc? Extra: How can I add space to the end of each loop so the data doesn't look clustered? Key 0 Fall 1 Spring 2 All-year PHP <? try { $pdo = new PDO ("mysql:host=$hostname;dbname=$dbname","$username","$pw"); } catch (PDOException $e) { echo "Failed to get DB handle: " . $e->getMessage() . "\n"; exit; } $query = $pdo->prepare("SELECT course.name, course.code, course.description, course.hours, semester.semester, semester.year FROM course LEFT JOIN major_course_xref ON course.id = major_course_xref.course_id LEFT JOIN major ON major.id = major_course_xref.major_id LEFT JOIN course_semester_xref ON course.id = course_semester_xref.course_id LEFT JOIN semester ON course_semester_xref.semester_id = semester.id"); $query->execute(); if ($query->execute()){ while ($row = $query->fetch(PDO::FETCH_ASSOC)){ print $row['name'] . "<br>"; print $row['code'] . "<br>"; print $row['description'] . "<br>"; print $row['hours'] . " hrs.<br>"; print $row['semester'] . "<br>"; print $row['year'] . "<br>"; } } else echo 'Could not fetch results.'; unset($pdo); unset($query); ?> Current Display Computer Programming I CPSC1400 Introduction to disciplined, object-oriented program development. 4 hrs. 0 2013 Desire Display Computer Programming I CPSC1400 Introduction to disciplined, object-oriented program development. 4 hrs. Fall 2013

  Read the article

• dynamically scale images in php jpg/png/gif

  - by Patrick

  Is there a simple way of dynamically scaling an image in php? Id like to specifically use some kind of function where i can insert it into my heml such as <img src=image.php?img=boss.jpg&width=500> and of course it would then scale the image to whatever height constrains it to 500px wide i appreciate all input, thanks. EDIT does need to include jpg png and gif file types

  Read the article

• buttons in a datagrid in flex

  - by markblue777

  Hi All, i am using a data grid in flex and i am generating data from a mysql server. However, my problem is with adding a button within the datagrid so each row has one. i have set the columns itemRenderer to mx.controls.Button although with the buttons shown in the grid there is no label on them (even though one has been set) and the assigned click event does not trigger when hitting the button. anyone have any ideas or guidance on what i am doing wrong. Thanks Mark

  Read the article

• get date from string php - UK date

  - by julio

  Hi-- I have a UK date in the format "06/Apr/2010 13:24" that I need to insert into a mysql db date field. The PHP strtotime function can't handle this string-- has anyone got any ideas other than writing a custom function? Thanks!

  Read the article

• scriptdata not working in uploadify

  - by Vinoth13

  Hi Friends i am using uploadify for my project.. in that i need to pass some data to upload.php to insert it in database. i am using the below code for sending data and getting it using $_POST in that upload.php file but its not getting those values. $("#fileupload").fileUpload({ 'uploader': 'uploadify/uploader.swf', 'cancelImg': 'uploadify/cancel.png', 'script': 'uploadify/upload.php', 'scriptData' : {'name':'name','status':1} Can anyone help me on this ..

  Read the article

< Previous Page | 608 609 610 611 612 613 614 615 616 617 618 619  | Next Page >