Search Results

Search found 6 results on 1 pages for 'binay'.

Page 1/1 | 1 

• EXCEL 2007 macro

  - by Binay

  I have a macro which connects to db and fetches data for me and makes it comma separated. But the problem is the comma is getting appended to the last row, which I don't want. I'm struggling here. Could you please help out? Here is the part from the code. If cn.State = adStateOpen Then Rec_set.Open "SELECT concat(trim(Columns_0.ColumnName), ' ','(', 'varchar(2000)' ,')') columnname FROM DBC.Columns Columns_0 WHERE (Columns_0.TableName= " & Chr(39) & Tablename & Chr(39) & "and Columns_0.Databasename=" & Chr(39) & db & Chr(39) & ")ORDER BY Columns_0.Columnid;", cn 'Issue SQL statement If Not Rec_set.EOF And Not Rec_set.EOF Then Do Until Rec_set.EOF For i = 0 To Rec_set.Fields.Count - 1 strString = strString & Rec_set(i) & "," Next strFile.WriteLine (strString) strString = "" Rec_set.MoveNext Loop Here is the result I am getting. EMPNO (varchar(2000)), ENAME (varchar(2000)), JOB (varchar(2000)), MGR (varchar(2000)), HIREDATE (varchar(2000)), SAL (varchar(2000)), COMM (varchar(2000)), DEPTNO (varchar(2000)), I don't want the last comma.

  Read the article

• How can I create a dynamic form using jquery

  - by binay

  How can I create a dynamic form using jquery. For example if I have to repeat a block of html like <div><div>Name: <input type="text" id="name"></div><div>Address: <input type="text" id="address"></div></div> for 3 times and show them one by one and also how can I fetch the value of this dynamic form value.

  Read the article

• In jquery how can I keep track of multiple ajax request called from one function

  - by binay

  I'm using jquery and in one function I'm calling multiple function which are doing different ajax request for example function contactForm(){ loadCountryList(); loadMyData(); checkUserType(); // doing my stuff } How can I know if all the ajax request are completed so that I start doing my stuff in the end? I don't want to call them one by one to minimize the request time. any suggestion will help me a lot.

  Read the article

• how can I get week's start date and end date from any given date

  - by binay

  Using PHP how can I get week's start date and end date from any given date. For example 2010-05-13 is Thursday so how can I get 2010-05-09 (SUN) and 2010-05-15 (SAT)

  Read the article

• Any suggestion for mobile datepicker

  - by Binay

  I'm building mobile widget based on javascript and html for which I need a calendar module build on javascript. I tried UI datepicker but its quite slow when runs on phone. any suggestion is going to help me alot.

  Read the article

• jquery change not working incase of dynamic value change

  - by Binay

  In jQuery how can I track onchange event if the value of textbox is changing dynamically from some other event. I tried this but its not working: $("#txtbox").change(function(){ alert("change"); });

  Read the article

1