mgdvicky
Last Activity: Apr 21 '15, 05:30 AM
Joined: Feb 20 '14
Location:
-
That is my problem. I don't know how to write join query for this criteria. -
I mean whatever itemcode I use in finperiod = 'jan-14' and also I use same itemcode in finperiod = 'feb-14'. Sometimes, I don't use same itemcode whatever I used in finperiod = 'jan-14'. I need the output for that unused itemcode. Ex: (103, 'jan-14', 'fy2014') this same itemcode I don't use for finperiod = 'feb-14'. So the output is : 103.Leave a comment:
-
How to compare same column and multiple values in same table?
Table1 fields and datas : (itemcode,itemd esc)
(101, aaa)
(102, bbb)
(103, ccc)
(104, eee)
(105, fff)
(106, ggg)
(107, hhh)
Table2 fields and datas : (itemcode, finperiod, finyear)
(101, 'jan-14', fy2014)
(101, 'feb-14', fy2014)
(102, 'jan-14', fy2014)
... -
How to Generate unique random number?
Can someone tell me a good method for automatically placing a unique random number in a mysql database table when a new record is created. -
mgdvicky started a topic Generate unique random number perform insert,update,delete show into text box value?in JavascriptGenerate unique random number perform insert,update,delete show into text box value?
I need to generate unique random number to show into the text box value and also perform insert,delete,u pdate operation using java script. I need your solution which is better way using mysql or java script.? I'm trying java script and facing problem i could not show unique id.?
java script code:
Code:document.getElementbyId("random").value=Math.floor(Math.random()*10); -
mgdvicky started a topic One primary key in one table linked to two foreign keys in two different tables?in MySQLOne primary key in one table linked to two foreign keys in two different tables?
how to point two table foreign key to references same primary key in other table?
my database sample structure is like,
table1 - user(id (pk),name)
table2 - question(id (fk),type)
table2 - choice(id (fk),choice) -
sure. chaarmann thanks a lot for your valuable response.Leave a comment:
-
Thank you chaarmann. I'm using this URL also, http://localhost:8080/FinalChapter/Ajaxss. but there is no interaction between ajax.
If i am using action attribute in form tag it'll works fine to interact with servlet, but not with ajax..
servlet code:
...Code:public class Ajaxss extends HttpServlet { private static final long serialVersionUID = 1L; protected void doPost(HttpServletRequest request, HttpServletResponseLeave a comment:
-
Dojo xhrPost ajax call not response
If i submit a form, there is no interaction between ajax&servlet.
...Code:function postform() { var xhrArgs= { url: "../Ajaxss", form: dojo.byId("myForm"), load: function (message) { dojo.byId("Message").innerHTML = "<div style=\"color:green\">"+message+"</ -
mgdvicky replied to The entered dijit value doesn't display the Json string, need solution thanks millionin Javascriptya,dormilich i got it thankyou.
Code:var jsonstr= {"productcode":dijit.byId("productcode").attr("value"),...}Leave a comment:
-
mgdvicky replied to The entered dijit value doesn't display the Json string, need solution thanks millionin JavascriptThanks Dormilich, I'm new to JSON and DOJO, Could you please so kind and modify my coding? Thanks in advance... :)Leave a comment:
-
mgdvicky started a topic The entered dijit value doesn't display the Json string, need solution thanks millionin JavascriptThe entered dijit value doesn't display the Json string, need solution thanks million
...Code:[B]MY HTML CODE:[/B] <script> require(["dojo/parser", "dojo/json", "dijit/form/FilteringSelect", "dijit/form/TextBox", "dijit/form/Textarea", "dijit/form/Button", "dijit/form/ValidationTextBox", "dijit/form/DateTextBox"]); </script>
No activity results to display
Leave a comment: