I sort of know why this is happening. Just not sure
how to correct it.
My query:
SELECT
Reg.firstname,Reg.lastname, Profiles.ProfileName
FROM Profiles
INNER JOIN Reg ON (Profiles.LID = Reg.RegID)
INNER JOIN PSkicerts ON Profiles.ProfileID =
PSkicerts.ProfileID)
where Profiles.Status != 2
T
--- Jay Blanchard
<[EMAIL PROTECTED]> wrote:
> My suggestion is that you work some basic PHP/MySQL
> tutorials and use
> the PHP general list ([EMAIL PROTECTED]) for
> questions like
> this. Make sure you have RTFM, STFA, and STFW before
> posting, those guys
> can be merciless.
>
Jay, thank you
I need to convert database values into php variables.
Let me explain:
i.e.
select firstbase, secondbase, thirdbase, home from
allstars where firstbase = 122;
Now I want to use all those field names as variables
with the same record information they would have if
you just ran the above statement
I have a select, from, where, query set up.
There are a number of "inner joins" in it as well.
Now what I noticed is if there are some null fields in
the records, nothing will get returned. If I remove
those particular joins (where the NULLS are), the
record is returned.
Does this sounds like a
--- Roger Baklund <[EMAIL PROTECTED]> wrote:
> The WHERE clause describes EACH of the rows you get
> in the result. No
> one row can have a value in the School column equal
> to "Columbia" AND
> "Stamford" at the same time. You should use OR
> instead of AND.
>
Thank you Roger. That is one of
--- [EMAIL PROTECTED] wrote:
> There is nothing weird about that behavior. You
> asked for all of the rows
> where the School column has both of two different
> values at the same time.
I thought joins were difficult to comprehend ;)
> Try an OR instead or use the IN() operator.
>
> WHERE Sc
or maybe it's me :)
Anyway here is my table
++--+
| RecordID | School |
| PID,AI,INT | Varchar|
++--+
| 108 | Columbia |
+|--+
| 108 | Princeton |
+|--+
| 108
--- Stuart Felenstein <[EMAIL PROTECTED]> wrote:
>
> --- Roger Baklund <[EMAIL PROTECTED]> wrote:
>
>
Yes, I had not included in my original post I wanted
just the area code returned. It works -
select SUBSTRING(Telephone, 1 ,3) from SignUp
where
Left (Telephone, 3
--- Roger Baklund <[EMAIL PROTECTED]> wrote:
> It's a bit unclear what you are trying to do. Are
> you trying to find all
> numbers within a 3 digit area code, i.e. numbers
> starting with some 3
> digits? Or are you trying to find numbers with any
> of the three first
> digits equal to 4?
>
--- sol beach <[EMAIL PROTECTED]> wrote:
> Of course you do.
> You are asking for all of Telephone to be returned.
> Duh!
>
>
> > I'm trying something like this but still getting
> back
> > the whole string:
> >
> > select Telephone from SignUp
> > where
> > Left (SUBSTRING(Telephone,1,3), 3
--- Stuart Felenstein <[EMAIL PROTECTED]> wrote:
> I'm storing telephone number (US) in 10 digit
> varchars. If I want to do a search on just the area
> code, is there a way to limit it to just the first 3
> digits of the string ?
>
> Thank you
> Stuart
>
I'm storing telephone number (US) in 10 digit
varchars. If I want to do a search on just the area
code, is there a way to limit it to just the first 3
digits of the string ?
Thank you
Stuart
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:/
I'm creating a search form, the query is dynamic.
Meaning user can select 1 or all options.
All options translates to about 40 "where" statements,
including 1 -3 full text searches.
Is this too many where statements ? Do I need to watch
out for anything.
Looking for any advice on this issue.
Th
--- Heikki Tuuri <[EMAIL PROTECTED]> wrote:
> Stuart,
>
> you probably have
>
> skip-innodb
>
> in my.cnf.
>
> Best regards,
>
> Heikki Tuuri
Heikki - Nope , doesn't seem so. My.cnf is below.
Also, I'm guessing that if it was set to skip-innodb,
I wouldn't not have had the ability to chang
--- Stuart Felenstein <[EMAIL PROTECTED]> wrote:
> I'm not sure what happened but when I ran some test
> yesterday on a "transaction" it failed. Being
> puzzled
> I started digging around. I have come to find out
> that all the tables involved we
I'm not sure what happened but when I ran some test
yesterday on a "transaction" it failed. Being puzzled
I started digging around. I have come to find out
that all the tables involved were now set to MyISAM.
Obviously transactions wouldn't work.
The odd thing that I'd like to figure out is ho
--- Paul DuBois <[EMAIL PROTECTED]> wrote:
> There's a space beteeen the function name and the
> following
> parenthesis.
>
Yes, that and not remembering I'm still on 4.0.22 :)
Yeesh...sorry Paul.
Switched to TO_DAYS ..no diff I guess
Stuart
--
MySQL General Mailing List
For list archives
Does DATEDIFF only work with actual dates input i.e
('2004-12-05'
Or couldn't I do :
Select DATEDIFF (StartDate, EndDate) AS DaysBtwn from
mytable?
(StateDate,EndDate are date columns from db)
I'm generating a syntax error on this above.
Stuart
--
MySQL General Mailing List
For l
--- [EMAIL PROTECTED] wrote:
> I think you need an UPDATE statement
> UPDATE MyTable set EndDate=DATE_ADD(InitOn, INTERVAL
> LenChoice DAY) WHERE
> RecordID = ;
>
> Insert *always* creates new records if successful
> and cannot be used to
> modify them.
> Update *always* updates recirds in pos
I'm trying to build an insert query that will add a
value into a field , after the first insert query adds
the record.
Relevant table information:
+-+-++--+
| RecordID| InitOn | LenChoice | EndDate |
+ [PrimID,AutoInc]| [Date] | [int]|
While what I'm working on is only a test database, I'd
like to see what I can preserve.
I used a data dumping program to create records in my
database. However I'm not sure how I messed up , but
here is the problem.
I have 1016 records in a particular table. The first
column is a Primary ID Int
--- Brent Baisley <[EMAIL PROTECTED]> wrote:
> It depends on whether you are tracking info for
> individual users
Individual users (lucky me!)
> Now, if you want to keep separate logs for each
> user, you need to
> create a "log" table. The log table would have the
> following fields:
> relat
--- Jay Blanchard
<[EMAIL PROTECTED]> wrote:
> [snip]
> 1- I need a way to mark (somewhere) that the record
> came up in a search. i.e. 700 records were returned
> in a search, each one needs to a) be marked that it
> came up in a search b) that number needs to be
> incremented
>
> 2- Step fur
I'm not even sure what this would be called, but maybe
someone (or more then one) can give me some pointers
and where to learn how this is down:
Someone does a search on my system:
1- I need a way to mark (somewhere) that the record
came up in a search. i.e. 700 records were returned
in a search
--- Bernard Clement <[EMAIL PROTECTED]>
wrote:
>
> You will get your answers by reading carefully the
> Date Time Functions
> in the MySQL Reference Manual.
>
This will tell me how to automatically update the
column in question ?
Stuart
--
MySQL General Mailing List
For list archives: http
While I'm figuring this needs to be addressed via my
scripting language wanted to ask here.
Customers will buy a block of time to use my service.
Time meaning "number of days". 90, 45, 60, etc.
Here are the fields relevant to this question:
PostStart [Date]
LenChoice [int]
DaysLeft [int]
Wh
Note to self, check variables for typos before posting
to list!
--- Stuart Felenstein <[EMAIL PROTECTED]> wrote:
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm trying to paginate my record results. Running
into a sql syntax error that is boggling my limited
brain cells.
The print out of my statement as it is parsed:
This is before the error occurs, the first 15 records
return fine:
WHERE VendorJobs.Industry IN ('3') AND
VendorJobs.JobTitle LIKE '%%
--- Brent Baisley <[EMAIL PROTECTED]> wrote:
> Quite possibly since 0 could also mean false
> depending on your
> comparison operator. For instance, using a generic
> if statement, these
> two would both evaluate to false:
> if(0)
> if(null)
>
> You should be very specific when checking for NUL
I have a query statement set up for record returns
based on various where statements. The select
statement consists of a number of joins. One of those
joins includes a field that is marked "no null".
Recently I did a mass insertion into the table. Into
this particular no null field were place 0'
--- "Adams, Pat 006"
<[EMAIL PROTECTED]> wrote:
> You could add a where condition that's always true
> to the main part of
> the SQL statement so that you can just tack on more
> clauses
> conditionally.
>
> $sql .= "SELECT PostStart, JobTitle, Industry,
> LocationState, VendorID "
> . "FRO
--- Chris <[EMAIL PROTECTED]> wrote:
> What I tend to do in this situation is have a WHERE
> array:
>
> $sql .= " SELECT PostStart, JobTitle, Industry,
> LocationState, VendorID FROM VendorJobs";
>
>
> $aWHERE = array();
> if(isset($s_Ind)) $aWHERE[] =
> "VendorJobs.LocationState IN ($s_Ind)"
--- Rhino <[EMAIL PROTECTED]> wrote:
> No offense, Stuart, but I really can't make out what
> you are asking; the
> question is bordering on incoherent.
Well it's probably true that I'm losing it :)
Chris though understood even through my inane
babbling.
Except while the statements are corre
Question - I'm creating a dynamic query (using PHP)
but my question I think is more related to mysql
syntax.
Right now I have these statements:
http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--- Jim Winstead <[EMAIL PROTECTED]> wrote:
> My point was that you can't compare a column with an
> array
> of numbers using the '=' operator. You have to use
> the IN
> operator, as in the line of code I posted:
Thank you Jim , it's working now!
Stuart
--
MySQL General Mailing List
For li
--- Jim Winstead <[EMAIL PROTECTED]> wrote:
> You can't compare a column with a comma-delimited
> list of numbers like
> that...
What should the seperator be then ?
Thank you
Stuart
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://li
I've had this going over on the php-general list.
Thought I would throw it out here . Running PHP 4.0.22
Keep getting this error -
SELECT PostStart, JobTitle, Industry, LocationState,
VendorID FROM VendorJobsSELECT PostStart, JobTitle,
Industry, LocationState, VendorID FROM VendorJobsWHERE
Vendo
I apologize for the missing information.
First the server was on 4.0.20 now on 4.0.22. Apache
1.3.x not sure of the linux
The local machine is windows xp with mysql v. 4.0.20a
I did the data transfer running Navicat, so that may
not be so clear to anyone, but the only options that
were enabled:
My database got hosed last night due to some version
upgrade.
Anyway an older copy was restored on the server. I
have a more recent backup on my local machine.
However, when I have done the data transfers I have
found that the table names were convereted to all
lower case.
I'm assuming when I pu
I'm having a difficult time getting a query to work
correctly.
I'm not sure, if this is proprietary to Dreamweaver or
not (that is what I do my application development in)
Anyway I have created a search page that is dynamic
(meaning up to the user to choose the criteria)
It all works fine provided
Hope this is not a bad suggestion. I'd suggest also
"looking" at something like x-cart-gold. I't s a php
/ mysql product and very robust for online ecommerce.
If you want some ideas about what an online store
would need and should contain , you might get some
ideas.
I'm not promoting the product
I had a transaction script that "was" working fine.
Now I think it maybe due to a "duplicate key error".
At least that is the error being printed out.
Here is the table "Profiles_Skicerts"[innodb]:
P_ID - PK, Normal Index (int)
Skicert - PK, Normal Index (varchar)
N_Year - int, allow null
L_Used -
mmitt.
Now I'm not totally sure how a rollback would effect
the one Myisam query. I mean it wouldn't , since
rollback is alien to myisam, so I probably need to put
a line in there to (whatever a rollback is in myisam
language) as well.
Stuart
--- Egor Egorov <[EMAIL PROTECTED]> wrote:
I'm relatively new to all of this but just about
finished setting up a transaction myself.
I'm doing something like this:
this is in php:( i also have functions set up for
"begin", "rollback" and "committ".
You should also set autocommitt to 0 .
Hope this helps!
Stuart
function run_query($sql
oblem, what if the first insert give a
> error, then you
> don't know. You have to check each statement for
> error and if no error
> if found in all the statements then issue a commit
> if not a rollback
>
> Osvaldo Sommer
>
> -Original Message-
> From: St
My statements are all working but I'm not sure if
things are set up correctly. I say this because at
one point the first $query failed, yet the rest of
inserts wre committed. Now I believe I need to set
autocommit to 0 , yet the query failed due to a syntax
error. Hence the rule about 0 records e
I have a slight dilemma. I am using transactions to
insert data into multiple tables. All but one table
is Innodb. That one is Myisam and it's left as such
because its one text column, so I want the benefits of
full text search.
Still I need this transaction to somehow include this
entry.
Two
No :),. cause it seems that those formats are for
outbound, db ->.
I was looking for the other direction.
Stuart
--- Jeff Smelser <[EMAIL PROTECTED]> wrote:
> On Thursday 14 October 2004 03:12 pm, Stuart
> Felenstein wrote:
> > Thanks , I know the page and have the links
&g
Thanks , I know the page and have the links
bookmarked!
Stuart
--- Jeff Smelser <[EMAIL PROTECTED]> wrote:
> On Thursday 14 October 2004 02:45 pm, Stuart
> Felenstein wrote:
>
> > Apparently, mysql does not like the format
> > "MM/DD/"
> > T
Hi,
I am taking user input via a calendar widget (guess
it's js)
Apparently, mysql does not like the format
"MM/DD/"
Then again I tried it around , still no dice.
It's intended to go into a Date" column.
Is there a way I can correct it right within my query
?
Stuart
--
MySQL General Mail
Sorry I found out about Last Insert_ID right after
writing this. I guess the correct sequence is
check manual then post to list ?
Stuart
--- Stuart Felenstein <[EMAIL PROTECTED]> wrote:
> I'm in the midst of writing out some code that will
> take data from a huge form an
I'm in the midst of writing out some code that will
take data from a huge form and write it to the
database.
All the tables for insertions are innodb so i'm going
(or trying too) with the "one stop shop" approach -
transactions.
Question:
The first table I write too has as it's first column
an aut
Does application validation constitute all that is
needed for qualifying data prior to an insertion in
the database ?
Translated, If I have checked via my forms validation
things like required fields, character input, etc,
are there still checks through MySQL before the insert
happens ?
Thank y
See interspersed:
--- Joe Audette <[EMAIL PROTECTED]> wrote:
> If you are saying the user would navigate through
> multiple pages updating a table on each page and you
> want to treat all the updates collectively as one
> transaction, that is a bad idea.
I agree, that is what I am trying to not
This maybe somewhat of a silly question.
Scenario - I am pretty much a noob at both relational
databases and web programming. I've built most of my
pages using a RAD tool that, for the most part, does a
decent job , if you keep it fairly simple.
One of the limitations is inserts & updates are d
See interspersed.
--- [EMAIL PROTECTED] wrote:
> Let's do this verbally and maybe the database
> structure will become
> intuitively apparent
>
> You are hosting a website that supports job seekers
> (maybe more but let's
> concentrate on just this side of it)
Yep, there is the employer si
ase take the time to correct me and fill in any
> gaps. Please DO NOT
> attempt to make any data definitions at this stage.
> I need to understand
> what data you are going to maintain verbally before
> I can help you
> translate it into storage requirements.
>
> Shawn Gr
Shawn,
When I read your examples, it is clear as a bell.
When I try to map it into my situation it becomes more
difficult to clarify :)
Using other job boards as examples, there are a couple
of ways to go.
Most of the bigger players offer job seekers the
ability to store 5 resumes online. These
Great example and my apologies because as you know
we've been down this road before.
Side note - once again I did not provide my acutal
table names , this time they haven't been created as
of yet.
Let me skinny this down though a bit and focus on one
aspect of my design connundrum.
Remember I
I've worked through some of this but still would like
some opinions. Maybe it's not clear but I haven't
received any responses.
Basically to tie the records together I will use the
recordID (auto incrementing) in every table where the
records are written.
Then I can grab everything out of tha
I'm not sure , can't resolve in my mind if this is a
M2M or something else.
I have 5 tables, users may enter multiple records in
each table. The only trick is (for me) is how to tie
a unified record together across all of them.
I'll try to illustrate, and only use 2 tables to keep
it brief.
T
I think I may have discovered one of my issues, is
memberID in Table2 was primary key. Should not have
been. As far as the error messages in removing key,
I'm still unsure.
Stuart
--- Stuart Felenstein <[EMAIL PROTECTED]> wrote:
> Two tables:
>
> Table1 [innodb]
> us
Two tables:
Table1 [innodb]
userID.
addtlfields.
Table2 [innodb]
memberID.
addtlfields.
I created a foreign key in Table2 for memberID to
userID
set to "no action" on both delete and update.
I get this error when I try to add a record to table
2:"Cannot add or update a child ro
--- Paul DuBois <[EMAIL PROTECTED]> wrote:
> Are you trying to store telephone number values with
> the intermediate dashes? Such values are not
> actually
> numbers. You'll need to store them as strings, or
> else remove the dashes.
Yes, they made all the difference.
Set the field type to va
to be doing
> mathematical operations on a phone number that you
> use a varchar or
> char field.
>
> Maybe someone could correct me but aren't regex for
> strings only?
>
>
> Gary
>
>
>
>
> On Sat, 2 Oct 2004 04:59:45 -0700 (PDT), Stuart
I have a field "telephone".
Set to type :int:
Length: 11
It's not working correctly, and not sure if it's my
application or something I have wrongly set up for the
database.
We are talking about U.S. Telephone numbers here, so 7
digits (area code, exchange, unique number)
Now it seems everythin
nd joins. It also has inbuilt scripting and data
> value translation lookups.
>
> Timk
>
> -Original Message-
> From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
> Sent: 28 September 2004 09:57
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: Data fields from
plus lots of
> other goodies.
>
> www.it-map.com
>
> Tim Hayes
>
> -----Original Message-
> From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
> Sent: 28 September 2004 08:23
> To: [EMAIL PROTECTED]
> Subject: Data fields from one database to another
>
>
I want to move over 2 - 4 fields from a table in one
database , to a table in another. The field names are
not an exact match but they function identically (i.e.
username, password)
Whatever I'm using , web development garbage program
;) won't allow me to connect to 2 different databases
so I can
u
> want to avoid by requiring at least 1 or 2 input
> values.
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>
> Stuart Felenstein <[EMAIL PROTECTED]> wrote on
> 09/22/2004 03:11:16 PM:
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
tle like
> $job and city like
> $city and start like $start and industry like
> $industry and state like
> $state and taxterm like $taxterm";
> .
> .
> do the actual SQL call here.
>
> Stuart Felenstein wrote:
>
> >I'm back, trying to figure my way thr
ND process
> quickly. You should build custom WHERE clauses
> based on your user's
> input. This is definitely NOT a one-size-fits-all
> situation.
>
> Remember to use parentheses. When in doubt, spell it
> out. Don't make the
> query engine read your mind.
&g
I'm back, trying to figure my way through a somewhat
confusing set of conditons.
Sort of doing a sanity check here.
First explanation:
I've put together a search (the database) form that
has 6 inputs.
Just to clarify, the fields are
1-JobTitle
2-City
3-Start
4-Industry
5-State
6-TaxTerm.
The idea
ERVAL ". $daterange." day)";
See? Pretend you are a typist and BUILD the string as you want it
executed. Then do it.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Stuart Felenstein wrote on 09/13/2004 03:35:35 PM:
> Shawn - You answered the right questi
It's all good information. I need to be thinking security as well as generating
proper efficient code. All is appreciated.
Stuart
Harald Fuchs <[EMAIL PROTECTED]> wrote:
In article ,
[EMAIL PROTECTED] writes:
> I agree and I am sorry I forgot a very basic security practice. You must
> always
Not sure exactly what you mean by a SQL injection
attack. I'm thinking a string could be input as
opposed to an integer ?
The form itself constricts user to a set of choices.
Stuart
--- Harald Fuchs <[EMAIL PROTECTED]> wrote:
> I think this is bad advice, even for a novice like
> Stuart, becau
rsonally, I would
> do the first. (my logic: I don't need the variable
> except to use it in the
> very next statement and if I have to merge values
> and text once, anyway,
> why not just put the correct value into my original
> query)
>
> Please let me know if I ans
> Respectfully,
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>
> Stuart Felenstein <[EMAIL PROTECTED]> wrote on
> 09/13/2004 11:09:59 AM:
>
> > Ok, never mind . I guess a conditional loop is
> not
> > needed.
> >
&
Ok, never mind . I guess a conditional loop is not
needed.
Stuart
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I read through the parts of the manual that applied
but I might be missing something here.
I have a table where I'm trying to query the date with
a conditional statement. As you'll see , if 3 was the
condition then the statement should result in a list
of any entries made <= current date.
It j
I'm having a hard time getting my arms around how a
system's date process should work. Interested in
knowing how a real, online system that delivers
services or products to customers might work. Right
now I'll just be operating in North America.
As an example - a user does online banking. A bi
I have this query (below) that on it's own , directly
into the database seems to return all the records just
fine. Apparently though feeding it into a php loop,
the lack of "where" is causing great distress(at least
to the author)
I'm wondering where to put it though. Before each
join ? And then
I've been meaning to follow up on this post.
Can either Peter or someone expand and provide an
example of "get all information in a single query..."
Thank you ,
Stuart
--- Peter Lovatt <[EMAIL PROTECTED]> wrote:
> Hi
>
> What I do is to try and get all information in a
> single query and th
Wondering if there is anyone on the list who knows
this product .
Thank you,
Stuart
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
joined and
> summarized by MySQL into one list. One list will
> make the PHP loop
> simpler, smaller and faster.
>
> On Sep 8, 2004, at 2:12 PM, Stuart Felenstein wrote:
>
> > I'm confused about this response and am facing a
> > similar situation.
>
I'm confused about this response and am facing a
similar situation.
First, regarding the subject, what is the difference
between a PHP or whatever loop and a SQL query. All
the app code is doing is collecting the request and
handing it back to the database. The DBMS still has
to retrieve the da
Sorry, I'm not jumping in becasue I have an answer,
sorry Jeremy.
I posted a few days ago a question and wonder if this
thread , at least Shawn's response has any relevance
to my question.
That is! ; Is there really any difference between
using PHP to parse results back to the program or can
a SQ
confusing. I am taking my time
and wouldn't think of just throwing something up
unless it works in the 999,999,999 ways it should.
Thank you,
Stuart
--- Michael Stassen <[EMAIL PROTECTED]>
wrote:
>
> Stuart Felenstein wrote:
>
> > I'm hoping I can present this c
y
additonal OR's would get bypassed if I understand
correctly.
Sorry, I might just be thinking outloud.
Please do not boot.
Stuart
--- Stuart Felenstein <[EMAIL PROTECTED]> wrote:
> I'm hoping I can present this correctly. I'm trying
> to determine how to set up my where
I'm hoping I can present this correctly. I'm trying
to determine how to set up my where condition as, 1
way has already failed me. While I continue to
figure this out (i'm a noob), I hope asking for some
advice here won't be too awful.
There is one main table where data is inserted and
that I'm
od.
Sorry again!
Stuart
--- Paul DuBois <[EMAIL PROTECTED]> wrote:
> At 9:56 -0700 9/4/04, Stuart Felenstein wrote:
> >This maybe OT but perhaps somone has a clue here.
> >I am storing gifs in a Blob, well tinyblob field.
> >
> >I was under the assumption they could just
This maybe OT but perhaps somone has a clue here.
I am storing gifs in a Blob, well tinyblob field.
I was under the assumption they could just be
pulled out and shown on a web page similar to running
any other query.
Apparently not, someone have a hint ?
Thanks
Stuart
--
MySQL General Mailing
In my web design I have a side bar to provide quick
info and links to account information.
Examples would be account basics:
Welome : Name, Company, Last Visit , ..
One idea that brings me to this question:
In the side bar I list out how many resumes member has
on file, so:
Title1 - Then
Since the recent thread with Innodb table space, I
have had a concern for a while.
First, I use Navicat to administer mysql. This
includes table creation.
I don't notice this using a myisam table but when I
set up an innodb I find this item:
InnoDB free: 10240 kB
Does this mean the actual spac
reign key in resumes (eg
> resumes.memberID). MySQL doesn't have tools for
> implementing cardinality
> constraints, so you would have to do that in
> application code, ie grey out
> the add-a-resume button for members whose resume
> count exceeds 3.
>
> PB
> - O
es, who knows?). This
> comparison happens in
> your application code, not the database, as you need
> to decide whether to
> give the user the screen to enter another resume or
> to send the user a
> screen that says "So sorry but you already have your
> limit of resumes
t; Check your typing and try the query again. Also,
> remember that the row
> numbers used by the Limit clause start with 0, not
> with 1. In other words,
> you may want to try "Limit 0,1", not "Limit 1,1".
>
> Rhino
>
> - Original Message -
>
orresponds to your MySQL server version for the
right syntax to use near 'LIMIT -1' at line 1
Maybe formatting ?
Stuart
--- Stuart Felenstein <[EMAIL PROTECTED]> wrote:
> Wait!! Don't answer...it's that LIMIT
> thing.
>
>
> :)
> Stuart
&
ds like you really ought to do
> is give a walk
> through the tutorial.
>
> http://dev.mysql.com/doc/mysql/en/Tutorial.html
>
> If, after exploring these two links, you still have
> questions feel free
> to post them and people will be glad to be of
> assistance.
Wait!! Don't answer...it's that LIMIT
thing.
:)
Stuart
--- Stuart Felenstein <[EMAIL PROTECTED]> wrote:
> I'm tring to extract all records belonging to one ID
> in a table.
> BUT! I want to do it in piece meal. Meaning a
> record
> at a time
1 - 100 of 144 matches
Mail list logo