Search Results

Search found 62701 results on 2509 pages for 'sql function'.

Page 596/2509 | < Previous Page | 592 593 594 595 596 597 598 599 600 601 602 603  | Next Page >

• Connect to web-service/API in MySQL?

  - by Jesse Figueroa

  I'm creating a sql based procedure which can Accept a table load the values one at a time send the variables to a remote API Record the response of the API Write the response to a table for viewing later I have successfully implemented 1,2, and 5. I am hoping there may be some way of choosing an address to contact and for SQL to listen too for a response. Please let me know if you have any suggestions!

  Read the article

• my sql insert query not working

  - by Piyush

  I am inserting userId.It is displaying correct but inserting 0 in spite of actual userId. mycode- If(! empty($userIDToCheck) || $userIDToCheck != '' ) { echo $userIDToCheck; $sql = "INSERT INTOpnpdb.ruser(userid) VALUES ('$userIDToCheck');"; mysql_query($sql)or die(mysql_error()); echo "Done"; } Output : pi203713 Done But is database it is inserting "0"???

  Read the article

• Warning: sqlite_query() [function.sqlite-query]: attempt to write a readonly database

  - by Surya sasidhar

  The error-Warning: sqlite_query() [function.sqlite-query]: attempt to write a readonly database is coming whenever i try to insert values into a sqllite 1.1 database thru php program. php version is 5.2.

  Read the article

• SSIS to copy data from one table to another, where not in destination table

  - by alex

  I'm in the process of creating an SSIS package on a server (server1) that looks at the data in a sql db on another site (server2) and copies relevant rows across. The SQL statement required is: SELECT * FROM server2.ordersTable WHERE OrderID Not In (SELECT OrderID FROM server1.ordersTable This selects data from server1 which isn't in the table on server2 (based on order id) I then need to insert the result into a table on server1 How would I approach this? What components do I need etc...?

  Read the article

• Javascript !something && function()

  - by cpf

  Hi Stackoverflow, I have been looking at the source code of raphael (http://raphaeljs.com/index.html) and I see a lot of stuff like !variable && function() (e.g.: !svg.bottom && (svg.bottom = this); ) What does that exactly do? Does it check first and execute only if not true? Thanks.

  Read the article

• C++: how to declare template array as function parameter

  - by ~buratinas

  Very similar to this post How can I declare template array as a parameter in templated function? Something like this code: template <unsigned i> void my_func (char (&a)[i]); //yes, I do need that reference

  Read the article

• Using Jquery autocomplete - looking for example of overriding the filllist() function

  - by TLL

  I'm using the JQuery autocomplete plugin. I wish to override the implementation of the filllist() function. Can someone point me to an example of how to do this?

  Read the article

• How to connect to local database via website?

  - by Carlo

  Hi I have a website used by clients for reporting purposes and would like to give clients the option of my website reading their local database directly (instead of them providing data in a file format). In most instances their database would be SQL Express setup on their localhost. How can I connect to a clients local SQL server via my website, using asp.net / javascript etc? If the client provides their connection string properties, localhost would just refer to my server's localhost... Thanks

  Read the article

• How to build a database from an XSD schema and import XML data

  - by FreshCode

  I have a complex XSD schema and hundreds of XML files conforming to the schema. How do I automate the creation of related SQL Server tables to store the XML data? I've considered creating C# classes from the XSD schema using the xsd.exe tool and letting something like Subsonic figure out how to make a shiny database out of it, but not sure if it's the best way to approach it. Has anyone managed to elegantly import XSD files into SQL Server?

  Read the article

• A 16-digit hashing function

  - by Aly

  Is there a hash function that returns a 16-digit hex value (as MD5 returns 32-digit), or is there a library (for C++) in which I can use MD5 or SHA-1 which returns a 16-digit value

  Read the article

• Create a new instance in a static function of an abstract class

  - by arno

  abstract class db_table { static function get_all_rows() { ... while(...) { $rows[] = new self(); ... } return $rows; } } class user extends db_table { } $rows = user::get_all_rows(); I want to create instances of a class from a static method defined in the abstract parent class but PHP tells me "Fatal error: Cannot instantiate abstract class ..." How should I implement it correctly?

  Read the article

• Function point count given source code

  - by user354822

  Given the source code of a program, how do I analyze it and count the function points within it? Thanks!

  Read the article

• mysql restore file.sql syntax error using command line

  - by Jason

  when I input mysql -u root -p XXXX dbname < c:/filename.sql alway get this error "error 1064 <42000:" you have an error in your SQL suntax; check the manual that corresponds to your MySql server version for the right syntax to use near ..... what is wrong with this statement?

  Read the article

• How do I modify the hundards of records based on my query result?

  - by Nano HE

  Hi, I inserted some error record to my table, I can query via the sql below and found hundards of record marked with half. SELECT * FROM `marathon` WHERE gender = 'male' && distance = 'half'; How to write a SQL then I can modify the result rows distance from 'half' to 'full'. Thank you.

  Read the article

• Javascript syntax with () - function scope

  - by Fabien

  I am not very familiar with the Javascript syntax bellow. Can anyone shade light about the sense of this block? For what purpose? (function foo() { alert('bar'); })(); Thanks in advance.

  Read the article

• call a Javascript function from controller more than once (in Rails)

  - by mm1

  hi. I have a multiple file upload form(html5) and want to update my view as soon one of the images is transfered to my image server. Currently I upload the files with ajax and use response_to_parent to update my upload view when all images are transfered to the image server. Is it possible to call a Javascript function from the controller more than once per action? def upload params[:images].each do |file| upload_to_image_server(file) #page << Update upload View end end Thanks, Michael

  Read the article

• How do I keep connection in object explorer

  - by dotnet-practitioner

  This is regarding SQL server 2008 management studio.. I connect to different environment DB and every time I launch the Sql management console, I have to sign up every time to get those connections back in object explorer. Is there a way I could persist the connection so I don't have to login every time to different environments?

  Read the article

• captcha error Warning: session_start() [function.session-start]:Cannot send session cache limiter -

  - by user363534

  Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at C:\xampp\htdocs\program\sanweetha\quotation.php:280) in C:\xampp\htdocs\program\sanweetha\php\captcha demo\captcha_demo.php on line 1

  Read the article

• how can i call a javascript function when an ASP.net validation summary is filled

  - by july

  i have a validationSummary in my page. i want to call a javascript function after the validationSummary is filled. how can i achieve this? i think i should add an attribute in the code behind, but i can't figure out what is the attribute's key. any help?

  Read the article

• How write query to alter table in Sql Compact

  - by Shiny

  Im new to Sql Compact concept. How to Alter table in sql compact ? I have existing table and i need to add identity column.

  Read the article

• Using Entity Framework V4 - Mapping Stored Procedures with XML output

  - by ericwahner

  I have been attempting to implement the Entity framework into my project and unfortunately it seems like mapping an XML result set from SQL is not something that is supported. I also have issues with returning multiple result sets, though I understand that the EFExtensions was created to try to mitigate that issue. Is there a way to take a FOR XML EXPLICIT result from a SQL Stored Procedure and map it using the Entity Framework?

  Read the article

• PHP alias @ function

  - by SyaZ

  I'm new to PHP and I'm confused seeing some examples calling a function with a @ prefix like @mysql_ping(). What is it for? Googling / searching is not much of a help since @ gets discarded and 'alias' is not good enough keyword.

  Read the article

• Convert multiquery to a query using group by and so on

  - by ffffff

  -schema CREATE TABLE `ratings` ( `id` int(11) NOT NULL default '0', `rating` int(11) NOT NULL default '1', `rating_start` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) TYPE=MyISAM -myprogram.php foreach($ids as $id){ $sql = "SELECT rating FROM ratings WHERE id = '$id' AND rating_start >= NOW()"; $sql .= "ORDER BY rating_start DESC LIMIT 1;" $ret = $db->execute($id); } Can I teke same date from a Query? by using id IN (".implode(",",$ids).") and GROUP BY id

  Read the article

• C++ arrays as function arguments

  - by Dr. Acula

  Can I pass arrays to functions just as I would do with primitives such as int and bool? Can I pass them by value? How does the function know of the size of the array it is passed?

  Read the article

• Java: popen()-like function?

  - by Mark Harrison

  This is in the context of a local Processing program. I would like to run an external program to get some data. Is there a popen() or equivalent function I can use?

  Read the article

< Previous Page | 592 593 594 595 596 597 598 599 600 601 602 603  | Next Page >