Python Forum
Python Forum

Search Results
Post Author Forum Replies Views Posted [asc]
    Thread: Reading SQL scripts from excel file and run it using python
Post: RE: Reading SQL scripts from excel file and run i...
Thanks Ibreedan Now python code is working fine. But 2 problem's 1) I am not getting column header name when I run SQL scripts through Python. 2) How to auto increment next row in excel file. E.g I...
 saravanatn General Coding Help 2 2,563 Aug-23-2020, 04:49 PM
    Thread: Reading SQL scripts from excel file and run it using python
Post: Reading SQL scripts from excel file and run it us...
Hi All, I placed my SQL scripts in excel file and my python code needs to read the SQL code from excel and then run the SQL code from SQL Server using Python . If the fetch row is greater than zero t...
 saravanatn General Coding Help 2 2,563 Aug-22-2020, 06:13 PM
    Thread: help! this 'for' loop makes me crazy
Post: RE: help! this 'for' loop makes me crazy
Compare the first element in list with the rest of the element and append the minimum value in the element of the list and then remove the existing minimum element in list data_list = [10,20,8,50,6]...
 saravanatn General Coding Help 5 2,927 Jul-09-2019, 08:17 AM
    Thread: integer representing a 10-digit phone number
Post: RE: integer representing a 10-digit phone number
(May-13-2019, 08:13 PM)critter70 Wrote: @ichabod801 - my sincere apologies...of course I completely botch up my very first post. I was hasty in my post because I was running out the door to work. Ne...
 saravanatn Homework 5 27,531 May-17-2019, 09:29 AM
    Thread: Split String
Post: RE: Split String
g="Hello world ! what is your name ?" g1=g.split(' ') print(g1[0:3],end="") print(',',end="") print(g1[3:])
 saravanatn Homework 6 3,485 Mar-17-2019, 08:52 AM
    Thread: how to assign variables?
Post: RE: how to assign variables?
I think below code is what you looking for num1=float(input("Please enter A number")) num2=float(input("Please enter another number")) num3=float(input("Please enter another number")) if ((num1+num2)...
 saravanatn Homework 2 2,560 Mar-09-2019, 01:59 PM
    Thread: Python split and concatenate
Post: RE: Python split and concatenate
col array<struct< ---> It is SQL. Thanks Axel.
 saravanatn General Coding Help 5 3,707 Jul-31-2018, 08:22 AM
    Thread: Python split and concatenate
Post: RE: Python split and concatenate
Hi Axel, Thanks for your reply. I tried your program mylist = ["`col` array<struct< columnname:string,columnname1:int,columnname2:decimal(10,0),columnname3:decimal(9,2)>>"] for a in ","....
 saravanatn General Coding Help 5 3,707 Jul-30-2018, 03:30 PM
    Thread: Python split and concatenate
Post: Python split and concatenate
I am new to Python and using python 2.7 version I am trying to extract array column name using python. Array column is mentioned below: `col` array<struct< columnname:string,columnname1:int,co...
 saravanatn General Coding Help 5 3,707 Jul-30-2018, 05:44 AM

User Panel Messages

Log Out
My Profile
Pay your profile a visit
User Control Panel
Do some changes on your profile
My Messages
View private messages unread
Avatar
Change avatar
Signature
Change signature
Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020