How to get the values of the radiobuttonlist which will be selected in nested datalist to use it in muliti insert later i want to get all the values of the controls of radiobutton list to use them in multi insert statment in the code ...
Hello guys, I'm trying to implement a 'fade into' script which would affect two images : <script type="text/javascript"> $(document).ready(function(){ $('img').mouseover( function() { $(this).fadeOut(200, function() { $(this).attr({'src':'http://example/images/image.png'}); ...
Hi there, I want to convert bytes to GB. value= 8587321344 So it should be 8587321344/1024/1024/1024 But whenever I go to divide, the value is wrong... If I cast it into integer, it will be limited to 2147.... Can't find any type cast to long data type... Funny enough... How to perform this calculation to show correct output... Th...
I'm trying to parse the XML below so that I wind up with an array that looks like the sample included... I'm having a hard time figuring out how to get the attributes inside of the tags to output the way I want it to... The XML <cust rid="999999" memberid="12345" lname="Doe" fname="John"> <address memberid="12345" address1="1234 M...
Howdy - I'm a MySQL Noob. I have a table of various business listings and I am trying to populate a second table called cities that contains unique city names along with a count of how many listings per city. I'm able to do a SELECT statement that gets me this data fine like so: SELECT city,state,sum(count) FROM ( SELECT city,state, 1 A...
Comfortable in Adobe Dreamweaver CS3, is there a way to convert a website written in the Python language www.qingdynastyimports.com into Dreamweaver for those who aren't familiar in writing in code? thanks for any comments. ...
hi, i'm dynamically adding rows to a table using jQuery. the table is inside a div which has overflow:auto, thus causing a vertical scrollbar. i now want to auto-scroll my container-div to the last row - what's the jQuery version of scrollintoView(tr) ? thx ...
When I try the following: declare var_type VARCHAR2(10); begin var_type := 'B'; select case var_type when 'B' then 'Beans' when 'L' then 'Legumes' end from tableOfBeans ; end; I get an error saying ORA-06550: line 4, column 1: PLS-00428: an INTO clause is expected in this SELECT sta...
Hi all, I am passing String parameter into javascript . But it is not being called. this is my script: function downloadPopup(testing){ alert(testing); } I am calling the javascript like this from my jsp page: <% String testing = "DSfsdsfd" ; %> <a href="javascript:downloadPopup(<%=testing%>)" > Click </a> How to resolve it?...
Visual Studio 2008 | Silverlight 3 | SQL Server 2005 | Domain Services Class | Entity Data Model I have a database table "Students" with columns FirstName, LastName, Semester, ProgramOfStudy, Column etc....... The goal is to return a Total (number of students grouped by first letter of lastname), based on the first letter of the lastna...
Hi, I am using a insert into select from statement to insert the result set of a query into a table containing an identity column. I am consistently getting an error Cannot insert duplicate key row in object 'dbo.TABLE1' with unique index 'IX_TABLE1'. Please help ...
Suppose that I have a Table Symbols(Symbol, Value) and a Table SymbolValues (Symbol, Value) which contains a list of values for the symbol. How to choose maximum values fromt he SymbolValues table and insert into Symbols table. For Example, The SymbolValues Table has following values A 1 A 2 A 3 B 6 B 7 Then only A 3 and B 7 should b...
I have a problem using a table with an instead of insert trigger. The table I created contains an identity column. I need to use an instead of insert trigger on this table. I also need to see the value of the newly inserted identity from within my trigger which requires the use of OUTPUT/INTO within the trigger. The problem is then t...
COMMENT OUT below just for reference "" cursor.execute (""" CREATE TABLE yellowpages ( business_id BIGINT(20) NOT NULL AUTO_INCREMENT, categories_name VARCHAR(255), business_name VARCHAR(500) NOT NULL, business_address1 VARCHAR(500), business_city VARCHAR(255), business_state...
Hi, I need to insert data from table1 into table2. However, I would like to set the myYear column in table2 to 2010. But, there isn't a myYear Column in table1. So, my basic insert looks like: INSERT INTO `table2` ( place, event ) SELECT place, event FROM table1 Roughly, I'd like to do something like the following: INSERT INTO `t...
hi, i'm using a wysiwyg editor which has a .css applied - how can i get all its classes into a variable eg. allClasses = ['navi','main']? thx ...
Here's what I want to do: Insert some data being passed into a procedure into a new table, but also include some data from another table too. Example: INSERT INTO my_new_table(name, age, whatever) VALUES (names.name, ages.age, passed_in_data); But that won't work. I did check another question on here, but it was a bit much for my fe...
Hi! How can I in Ruby read a string from a file into an array and only read and save in the array until I get a certain marker such as ":" and stop reading? Any help would be much appreciated =) For example: 10.199.198.10:111 test/testing/testing (EST-08532522) 10.199.198.12:111 test/testing/testing (EST-08532522) 10.199.198.13:11...
Dear All, I am beginner to Joomla development, I have created a very simple module, How to create a form of three textfields in it, and then insert textfields data into database /. Any one can help ? ...
Hi Could someone tell me how to add a new line in a text that i enter in a mySql table. I tried using the '\n in the line i entered with INSERT INTO statement but '\n is shown as it is. Actually i have created a table in Ms Access with some data. Ms Access adds new line with '\n. I am converting Ms Access table data into mySql . But ...