Is it possible to search through blob text using sql statement?
I can do select * from $table where f1 like '%foo%' if the f1 is varchar, how about f1 is a blob? Any counter part for this?
Back in the day, there was a standard that I was taught a standard for modelling database entities using text only, I can't remember the name of the standard but it looked somehing like
TableName, Key, Column
Anybody know what that form was called?
I have some text files previously formatted in vim using "gggqG". Now I need to convert them to one line per paragraph format. I saw a way(using :g command) to do that before, but I have forgot it. Anyone knows?
Hi,
When text is selected in the iPhone OS, the user is given the option to copy/cut etc. How would I go about adding a new option here?
An example of this is in CourseNotes for iPad http://www.youtube.com/watch?v=VLQhKkgco_I where the option is used to look up on wikipedia (around 55seconds in).
Thanks
I tried to change the "List of Listings" text with the command
\renewcommand*{\lstlistlistingname}{List of XYZ}
before my \begin{document}. What's wrong with this?
By the way
\renewcommand*{\lstlistingname}{NewListing}
worked like a charm.
Thank you
I'm looking for the easiest way to sort an array that consists of numbers and text, and a combination of these.
E.g.
'123asd'
'19asd'
'12345asd'
'asd123'
'asd12'
turns into
'19asd'
'123asd'
'12345asd'
'asd12'
'asd123'
This is going to be used in combination with the solution to another question I've asked here.
The sorting function in itself works, what I need is a function that can say that that '19asd' is smaller than '123asd'.
I'm writing this in JavaScript.
I've seen questions to prefix zeros here in SO. But not the other way !!
Can you guys suggest me how to remove the leading zeros in alphanumeric text. Are there any built-in APIs or do I need to write a method to trim the leading zero's?
Example:
01234 converts to 1234
0001234a converts to 1234a
001234-a converts to 1234-a
101234 remains as 101234
2509398 remains as 2509398
123z remains as 123z
000002829839 converts to 2829839
I am displaying student attendance in Gridview from sql server. i choose apsent as A, present as P and leave as L. Now i would like to display A in red color, P in green in Gridview databind, not for header text. How is it. please help me
We are using C#.net & use access database code for import of text file specification into access table
is there any access database limit for this action, as we may have records 5 lac (500,000) ,will this process work for huge records??
If No then how can we handle huge records insertion in access database for same ?
Thanks
I have tried to embed the icalendar code in a email to be sent via indy with a content type text/calendar but it just hangs on the encoding of the email when I add as an attachment it just arrives as an attachment and does not prompt as other calendar request do. Has any one got example code of how to do calendar requests via indy?
i have a table (tbl_world) which look like this
id | first_name | last_name | age | class |
now i want to search the text which can be anywhere in first_name or in last_name
i m using below mysql query
"SELECT * FROM tbl_world WHERE REGEXP '".$word."' IN( first_name, last_name)";
where $word is user input (means if i search 'hell' then 'hello' as well as 'wellhell' also returned in result)
above query display error, please suggest me optimize method for search in mysql.
addition question: should i use LIKR or RLIKE?
How can I parse text and find all instances of hyperlinks with a string? The hyperlink will not be in the html format of <a href="http://test.com">test</a> but just http://test.com
Secondly, I would like to then convert the original string and replace all instances of hyperlinks into clickable html hyperlinks.
I found an example in this thread:
Easiest way to convert a URL to a hyperlink in a C# string?
but was unable to reproduce it in python :(
I was wondering if there was a way to extract all the values of a column, and then save each value into separate text files (labeled ANYTHING, 1-100 works fine).
I know how to do this through another language, but I'm using SQL Server 2008 with Microsoft SQL Server Manager and it would save me some time from figuring out how to do it through C#.
I would like to include a rich text editor in a pygtk drawing area for an application i am developing. The editor ( a small resizable widget ) should be able to move around the drawing area like a rectangle. I am not sure how to start as I am pretty new to PyGTK. thank you !
i am having label and text on to it is loaded by dynamically is connecting to radio and displays name of song ,i am getting problem with song name is crosses my play button present on my player ...so i want to limit while display...
I would like to extract some text between two points in a string, in Javascript
Say the string is
"start-extractThis-234"
The numbers at the end can be any number, but the hyphens are always present.
Ideally I think capturing between the two hypens should be ok.
I would like the result of the regex to be
extractThis
I want to change the text of the top address bar without reloading, I know the methods window.location.href and window.location.hash, but I want to do it without appending a "#" to the URL.
Is it possible?
Thanks.
Hi there,
I have a piece of text that gets handed to me like:
here is line one\n\nhere is line two\n\nhere is line three
What I would like to do is break this string up into three separate variables.
I'm not quite sure how one would go about accomplishing this in python.
Thanks for any help,
jml
This might have been asked in another way. I am not doing it on the fly however. Once in a while we get pieces of content in word files that have em dashes, bold, italic text and block quotes. Is there a good tool to convert this into a clean html code.
Otherwise what other approaches people take.
Whenever I add a layer for Core Animation either from the nib or programatically, the NSTextFields (labels) in my interface get messed up. Here's a screenshot from Apple's BasicCocoaAnimations example. (Look at the text fields on the left, somehow they're drawn sharper than normal)
Note that if I add a layer in IB then it also gets messed up in IB itself before I even run my app.
Hi all
I have a text file like below
2 1 2
5 10 13 11 12 14
2 0 1
2 99 2
200 2
1 5
5 1 2 3 4 5
1 0
0 0
I want to read file line by line, and read the umbers from each line. I know how to use the stream to read a fixed field line, but what about the non-fixed line?
Best Regards,
By highlight I mean the thing you do to text when you drag your mouse over it. If you use imgur.com then you know what I want. I can't find anything about this anywhere, it's frustrating. help?
This is likely a very simple question, but how do I get text in SVG to stretch to fit its container?
I don't care if it looks ugly from being stretched too long or high, but it needs to fits its container and be as big as possible.
Thanks