raise error within MySql function
- by Don
Hi,
I've created a MySql function and would like to raise an error if the values passed for the parameters are invalid. What are my options for raising an error within a MySql function?
Thanks,
Don
Search Results
Search found 17982 results on 720 pages for 'computed values'.
Page 351/720 | < Previous Page | 347 348 349 350 351 352 353 354 355 356 357 358 | Next Page >
-
-
Programmatically find complement and supplement of colors?
- by Mohit Deshpande
Is there a way to find the complement or supplement of a color given its RGB values? Or can it only be found for certain colors? How would someone go about doing this in Java?Read the article
-
How to use T-SQL MERGE in this case?
- by abatishchev
I'm new to T-SQL command MERGE so I found a place in my SQL logic where I can use it and want to test it but can't figure out how exatcly should I use it: IF (EXISTS (SELECT 1 FROM commissions_history WHERE request = @requestID)) UPDATE commissions_history SET amount = @amount WHERE request = @requestID ELSE INSERT INTO commissions_history (amount) VALUES @amount) Plase suggest the proper usage. Thanks!Read the article
-
Given an array of integers [x0 x1 x2], how do you calculate all possible permutations from [0 0 0] t
- by user319951
I am writing a program that takes in an ArrayList and I need to calculate all possible permutations starting with a list of zeroes, up to the value in the corresponding input list. Does anyone know how to iteratively calculate these values? For example, given [ 1 2 ] as input, it should find and store the following lists: [0 0], [1 0], [1 1], [1 2], [0 1], [0 2] Thanks!Read the article
-
MySQL - Extracting Time in correct format
- by mouthpiec
Hi, I have a table with a coloumn of type "time", and the values in this coloumn are stored as follows: 20:45:00, 18:00:00, etc. Now when displaying the result, I am not getting the minutes, but just 00. I am using the following to get the time: SELECT TIME_FORMAT(time, '%h:%m') as time FROM ......... etcRead the article
-
Reading the text using regular expressions
- by deep
(Sales (Type 0 0 0 0 000 0 0 0 0) "Product" "ProductType" "" "0000" "0000") ;;ProductName 000 hai i just want to extract all values from the above text line using regular expressions. how to write regular expression for this. am using c#Read the article
-
Passing a string parameter in a JavaScript function on MVC
- by PlayKid
Hi there, I tried to pass a string value into a JavaScript function like below: <%= "'" + prop.property_description + "'") %>) But it does not seems to be the best option, is there a better way to do the above without concatenate the string values with "'"? ThanksRead the article
-
Access iphone setting preference
- by Manu
Hi, I would like to access smtp outgoing mail server address from global setting-mail-accounts-outgoing mail server. Is there any public API available now to get the user global setting values? Thanks ManojRead the article
-
What does 'MGMTCLASS' of a dataset describe?
- by Raja Reddy
While allocating a dataset, What does MGMTCLASS of a dataset describe? To my knowledge it gives the retention and expiration period that it is gonna reside on disk and the possible values I have observed are BKUP35, NOBKNLIM etc. What are these stand for and what else are the possible value for this parameter? Hope I put my question exactly, please lemme know if i missed something...Read the article
-
how to count number of elements of same value in a matrix?
- by niko
Hi, Does anyone know how to count the number of times the value appears in a matrix? For example if we have a 1500 x 1 matrix M (vector) which stores the values of weekdays (1 - 7) and would like to count how many Sundays (1), Mondays(2),... , Saturdays(7) are stored in M? Thank you!Read the article
-
Cannot get Request.Form by name in ASP.NET
- by Nissan Fan
I have an ASP.NET page which utilizes jQuery for an autocomplete-type scenario. The jQuery tucks the actual selected values into a hidden field it creates on the fly, but for some reason I cannot get the value of that standard HTML field on postback by calling Request.Form["HiddenFieldName"]. I can see it by ordinal in the Request.Form object, but if I add/remove controls it will break. Any suggestions?Read the article
-
activerecord search conditions - looking for null or false
- by Daniel
When doing a search in active record I'm looking for record's that do not have an archived bit set to true. Some of the archived bits are null (which are not archived) others have archived set to false. Obviously, Project.all(:conditions => {:archived => false}) misses the projects with the archived bits with null values. How can all non-archived projects be selected wtih active record?Read the article
-
How to use split in sql 2005?
- by meenakshi
Table column has values with comma separated for ex: (1,2,3) How to split this like 1 2 3 or 1 2 3 in sql2005.Read the article
-
ScaleTransform and CenterX
- by Vasco Correia
I have the following code <Canvas Width="800" Height="600"> ... In the UserControl I animate the ScaleTranform to 1. I want UserControl to "grow" from its center, but it "grows" from the upper left corner of it. The values in CenterX and CenterY do nothing. How can I make it Scale as I want? Thanks in advance.Read the article
-
how to split a string in TSQL
- by vaibhav
I have a varchar @a='a|b|c|d|e|f|g|h|i|j|k|l|m|n|o|p' , wich have | delimitted values. I want to split this variable in a array or a table. Do anyone have any idea about this.Read the article
-
Resolve value in C#/.net 2.0
- by Andreas
Is there a way to resolve values in a class structure using some xpath-style resolver? Exampel in code: string name = Order.Customer.Firstname; What i would like to do is something like this: string name = (string)X.Resolve(Order, "Customer.Firstname"); Is there a way to do this in C#/.net 2.0Read the article
-
how to bind ComboBox with DataTable
- by niko
Hi, I have the DataTable with following columns: id, Name, Description, ParentId and would like to create a WPF control (.NET 4.0 framework) which implements a combobox which displays the names which are bound to values of id. So when the user selects a name displayed in the combobox the behind logic has to retrieve its id value. I would be very thankful if anyone could show the way of doing the described above.Read the article
-
What is the easiest way to generate a Valid x:Name?
- by just in case
I am generating some Xaml based on some other source of input. In some cases I am generating x:Name values but they have invalid characters. I found this article on MSDN: XamlName Grammar Which describes the grammar of a x:Name tag but doesn't tell me how to actually apply this. Clearly there is some code to validate this name at runtime but what is the easiest way to actually fix up a string with invalid characters?Read the article
-
MySQL triggers and selecting data inside the trigger?
- by Stuart
Does anyone know if you can run a select statement to return values on the table that the trigger is assigned to from inside the trigger? Thanks in advance.Read the article
-
Is there a better way to set lots of required properties than sending as parameters in a Constructor
- by TooFat
I have a class that in order to do it's job needs to have 8 different property values set. I want to make sure that all 8 properties are set before trying to execute a method. I currently have all the parameters passed in and set via the constructor. Is there a better way to do this?Read the article
-
SQL results operation question
- by wali
I know I missasked the question, and that's probably the reason I can't find the solution myself: How do I take a result in a stored procedure and and change the data such as if column1 = AAA then column1=Hello else if column1 = BBB then column1 = goodbye and have the data return with the new values? ThanksRead the article
-
Kohana 3 get orm validation error
- by booze2go
if ($user->values($_POST)->check()) { $user->save(); } else { // How can i get the errors? } Any idea how that works? Thanks in advance!Read the article
-
How to get current route information in OnActionExecuting
- by Blankman
my urls look like: www.example.com/{languagecode}/{controller}/{action}/{id} where language code is en-us, etc. From the OnActionExecuting event, how can I get these values?Read the article
-
session problem in rails
- by piemesons
I am getting this error. No :secret given to the #protect_from_forgery call. Set that or use a session store capable of generating its own keys (Cookie Session Store). I deleted all the cookies, values from sessions table. Restarted my server.Still geting the same error and this code was working yesterday.Read the article
-
how to make a frequency function in matlab like the excel frequency function?
- by Ben Fossen
I have a list that is sorted and I want to know how many values are in each bin? I made bins using linspace(floor(fist_element_list), ceil(last_element_list), num_bins) Is there a built in function or an easy way to do this in Matlab? All I can think of is doing it manually. I would like a frequency function like the one in excel.Read the article
