473,569 Members | 2,402 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

longblob select

select * from s_proc where content = 'asiufhasiu'
the scrambling field was copied from the control panel of the binary field.
Is it possible to do straight query on the control panel directly against
the database/tables?
Thanks
Jack
Jul 20 '05 #1
1 2879
I meant to use longblob field as search key

"Jacky Luk" <jl@knight.co m> wrote in message
news:cf******** *@imsp212.netvi gator.com...
select * from s_proc where content = 'asiufhasiu'
the scrambling field was copied from the control panel of the binary field. Is it possible to do straight query on the control panel directly against
the database/tables?
Thanks
Jack

Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2426
by: Leon | last post by:
I am trying to send an email with an attachment. The problem is the attachment is stored in db where I have created a longblob field that contains the file so I have no idea how to specify the file path when I want to send an email. I have tried "" and "/" that didn't work. Any help? My code is ...
1
2028
by: ketulp_baroda | last post by:
Hi I am storing the attachment in the database. For some file the data gets stored in the database but for other files it gives a MySql error. For eg. when I am trying to attach the file say foo.txt it gets stored in database correctly whereas the file bar.txt gives an error. The error given is: Traceback (most recent call last): File...
0
3716
by: Bernhard Schmidt | last post by:
------=_NextPart_000_0099_01C34B87.28543020 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable hi all a question about checking the data of a longblob for equality. assume = the `data` field is of type longblob. the following statement returns = the image records with equal data.
0
1640
by: Jacky Luk | last post by:
I am storing binary files in my database, I've tried to retrieve it using the following statement select from s_proc where contents = 'ksajfha' but to no avail. Could anyone help? Thanks Jack
1
576
by: Jacky Luk | last post by:
select * from s_proc where content = 'asiufhasiu' the scrambling field was copied from the control panel of the binary field. Is it possible to do straight query on the control panel directly against the database/tables? Thanks Jack
1
3922
by: Davide | last post by:
Perche' non riesco ad inserire immagini opiu' grandi di 1Mb in un campo LONGBLOB? Ha forse il limite di 1Mb il campo LONGBLOB? Se si, posso modificare tale limite? Per le immagini inferiori a 1Mb e' tutto ok funziona perfettamente. Grazie a tutti, ciao.
3
2871
by: sudhakaranr | last post by:
HI ALL, I am new bie to mysql...I have 100 files as text files and each text file are having minimum 25 lines.I want to enter all the files in to Mysql DB. My query is, In mysql table, i have a columns like pid(PRIMARY KEY),content(LONGBLOB). In table, Pid has entries like p1,p2,p3..... Now in a directory, i have text files like...
1
1794
by: phpfreak2007 | last post by:
Hello, whenever I am using above 2 datatypes(longblob / longtext) my PC is not responding. I want to get data from the database (MySQL) to dataset. Thanks in advance.
3
6158
by: wizardry | last post by:
hello - ive inserted user names, etc. into the longblob but the path to the image is giving me a bit of a trouble. do i need to change a mimi type or transformation of some sort? i've changed it, to try to see it it would work but nothing. ok here is the table defenition that im uploading the path to:
0
7618
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7926
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8138
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7679
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6287
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5514
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5223
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3657
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
1228
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.