I was also getting this same error and I thank Gianganh for his help in
moving me along.
Now, using the solution above, instead of getting the SQL_INVALID_HANDLE, I
am getting the following:
" ('HY000', 'The driver did not supply an error!')"
Gianganh, did you also get this error? Or, if you
Thanks for your help...still learning. That makes sense.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscr
Good afternoon,
I am new to web and python development, but I have managed until now to get
pretty far along into a statistical analysis application without any real
problems. Web2py is great. The simplified concept of my app is that Users
connect to the local database and pull in data, the a
@Brian is right, the query is more complicated and it was just a
placeholder. When I get back in the office on Monday, I will run some more
speed tests. I am not the DBA and the city office where I am working
doesn't have access to SQL Server Management Studio. All of that is kept
by the IT
@Brian - The minute I sent you the email the problem returned.
I ran the following code:
test = db1.executesql('select * from table')
print test
print len(test)
"print test" yields None
Exception thrown from line "print len(test)":
" object of type 'NoneType' has no len()"
Seeing as this
@Brian -
Yeah, I do need to pull in those rows at one time. I thought I had
provided a workaround by only pulling a few thousand at a time and
then combining later.
I just got back in town from being gone for about a week. I come back and
now the problem I was having before is no longer
@Brian -
That is a great suggestion and I didn't know about that. I will get it.
The table current has about 50k rows and about 25 columns and I wanted to
pull in all of them. It creates a list of tuples. In the future, the
table might have potentially millions of records, but I would sti
@Tim - Thanks for the suggstion. I will upgrade to the newest version soon.
@Willoughby - Thanks for the reply. I doubt there is a row limit, but I
will look into it.
@Brian - The queries are more complicated than that, usually. I was just
giving an example. I have tried the exact same qu
Hey all,
I am running web2py version 2.4.6 and python 2.7.4.
I am using executesql to run raw ms sql queries, but I am having a problem
with them consistently yielding results. I am still in test right now as I
develop the app and I am running queries on a local database. I do not
know if
form = SQLFORM.factory(Field('x')).process()
>>return locals()
>>
>> and in index.html()
>>
>> {{=form}}
>> {{if form.accepted:}}
>>
>> {{pass}}
>>
>>
>> On Wednesday, 30 October 2013 14:55:50 UTC-5, Josh Myers wrote:
>>>
I have all this working the same way as Massimo suggested with matplotlib, no
problems.
But, I can't for the life of me figure out how to pass a variable into the
controller plot function from the view. This would be so I can, for example,
ask the user to choose a variable through a form and t
it needed that DRIVER statement. That was also the same
connection string that worked using pyodbc explicitly, so that makes sense
I guess.
On Thursday, October 3, 2013 4:53:55 AM UTC-4, Niphlod wrote:
>
>
> Il giorno giovedì 3 ottobre 2013 01:20:40 UTC+2, Josh Myers ha scrit
ql-server-native-client-11-0-oledb-provider/
>
> basically as long as there isn't a @ in it, the connection string will be
> used as it is with pyodbc, while if there is a @ in it, the connection
> string is "similar" to the usual user:pass@host/database
>
> On Wednesday, Oc
Brian and/or Massimo,
Did this issue ever get resolved so that the DAL can connect with windows
authentication? If so, what is the syntax for the connection string?
Thanks.
- Josh
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py
Nice! Thanks Massimo! I'm excited about the Conditional Fields!
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For
Thank you, everyone. You helped me answer #1 and I am appreciative.
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
F
Hey Group,
I am new to web2py and I am working to create a custom form from the
SQLForm.Factory with a conditional field built in.
I have two questions.
1. Using a conditional field based on the checkbox, I can get it to work
if I don't use the custom form, but I can't get it to work with t
17 matches
Mail list logo
