Hello Gabriel Genellina and Diez B. Roggisch,
Thanks for sharing your opinions. I agree with Gabriel when he
talks about the separation between the presentation and the DB level
access and the drawbacks of introducing character manipulation. The
problem that I am facing right now is that the p
Correction: I meant __builtin__.getattr method and not the other one I
mentioned.
:-)
Thanks
Raja
Raja Raman Sundararajan skrev:
> Hello guys,
> I have data stored in the database which has special characters
> like <, > etc.
> Case 1: Whenever I wanted to present the o
Hello guys,
I have data stored in the database which has special characters
like <, > etc.
Case 1: Whenever I wanted to present the output to a browser
I need to escape these special characters into the browser
equivalent like < > etc.( for example by using the cgi module)
Case 2: Whenev
Hi paron,
I am using PyRTF as of now and it seems to fit my need quite well
and it works like a charm :-).
I have made a wrapper around it so that it will easier for me to switch
the backend for generating the word/RTF docs later.
May be, it will be openoffice :-)
I appreciate your input. Thank
Hi Michel,
Well, Office 12 will have very many features. Thats true.
But my document needs to work in all versions of Office.
I hope that pyRtf generated file is fully rtf compatible. :-)
But so far I think it is quite okay.
To answer my first question:
> 1. do an align right of contents inside
Yeah, thats a good approach.
I have been fiddling around to implement that feature in elements.py
and RTF specification from msdn
However, I have not been successful thus far.
To answer my first question:
> 1. do an align right of contents inside a cell
Its not possible by speficying alignment in
Hello,
I have been playing around with pyRTF module for generating rtf
documents.
Its a very nice tool that fits my basic needs. However I have a problem
controlling cells in
a table.
I am not able to
1. do an align right of contents inside a cell
2. set backgroundcolor of a cell
3. I wonder i
Hi guys,
Thanks for your note Grant.
I had a look at the pyRTF and it seems to be quite impressive :-)
I actually works for my needs except the below, concerning cells in a
table
For cells in a table, pyRTF does not support
1. ALIGN_RIGHT
2. Cell background
Do you guys have any idea of how to
Hi Tim,
Thanks for your PyRTF suggestion. I am checking it out now
:-)
/R
--
http://mail.python.org/mailman/listinfo/python-list
Hello guys,
Is there any nice library to generate word documents using Python.
As of today I am generating a HTML document and then open it with MS
Word.
But the problem is that I am not able to control the pages in the
document and as a result of it the output looks terrible.
I have been usi
Hello guys,
I was investigating how one can use the "text indexers" in python
and I stumbled across several ones. eg., pylucene
I wanted to know how the algorithm of indexers look like. I have heard
people talking about B-Trees. But this info. is simply know enough. I
would like to know exactl
Oh! yes you can use re for that.
You just need to change the pattern a bit
I did not understand where the "title" will be so I have ignored it,
but I got something below which will be helpful for you
>>> value = """name:asasasasas\nrequest: play\ntitle"""
>>> reg = re.compile('Name:.*\\nrequest:.
try this. maybe this is what you want?
reg = re.compile('Name:.*\\n', re.IGNORECASE)
--
http://mail.python.org/mailman/listinfo/python-list
Hi Gregarican,
Thanks for sharing your code. One needs to add the % signs if one
wants to do wildcard searches using LIKE in the SQL server.
Do as Roger and Steve suggested '%raj%', now you can find the names
containing the word raj anywhere in the column.
just value = 'raj' is only going to fe
Ok guys! The problem seems to be much easier to be solved than first
thought. -->Shoot<--
Using the correct CreateParameter statement seems to do the trick.
For example creating the parameter as
cmd.CreateParameter(name,const.adVarChar, const.adParamInput, Size=16,
Value=value[i])
Yes, reportlad is a good tool for creating pdf and images
--
http://mail.python.org/mailman/listinfo/python-list
This does not seem to work well Roger
>>> value = '%raj%'
>>> cmd.CommandText = "select * from table_name where firstname LIKE ?"
result is 0 where I expected 4
/Raja Raman
--
http://mail.python.org/mailman/listinfo/python-list
Hello Steve, Roger and Pete,
Nice to read your reply. Well, I can do an assert check for
integers and then filter out hazardous SQL injection characters for
varchars and do a direct substitution of the filtered values with the
SQL statement.
But by using ADO, input strings can be treated as wh
Hi Gregarican,
I am the original poster and yes this is a production code level
problem.
Do u have inputs for a solution?
/Raja Raman
--
http://mail.python.org/mailman/listinfo/python-list
Yes, the statement you tried is a valid statement
also
>>> name = "%'WAITFOR DELAY '00:00:03'--%"
>>> "SELECT * FROM tb_name WHERE firstname LIKE '%s'" % name
is also valid.
My question is how to use the LIKE statements using ADO.in python
:-|
--
http://mail.python.org/mailman/listinfo/python-lis
Yes, Steve you have a very good point.
Gregarcian, I am using the parameterized SQL to avoid such
vulunerability.
for example in your example use
name = "%'WAITFOR DELAY '00:00:03'--%"
and directly substitute it to the statement
"select * from table_name where name like '%s' " % (name)
The server w
21 matches
Mail list logo
