| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
Comments:
<0> still have an error somewhere
<1> cyberic you'll need your zero placeholders with AS field-name in the select field-list
<2> the error is: error: stdlib.h don't exist the file or directory
<2> and mysql.h don't exist the file or directory
<1> are you using a makefile?
<2> no
<1> what o/s ?
<2> i have the C program and i compile with gcc
<2> linux
<1> might want to make a makefile, and in it break out the compile and the link on separate lines
<2> how?
<1> gcc test.c -g -c
<2> and then?
<1> gcc test.o -L/usr/local/mysql/ib -lmysqlclient -lz -o test
<2> i do it
<2> mm....no
<3> how can i loginto mysql
<3> mysql -u storo -h db3***2 -p db3***2
<3> i tried this
<2> it no is the solution
<0> insert into yesterdays_links (id,todays_impressions,todays_clicks,yesterdays_impressions,yesterdays_clicks) select id,todays_impressions as yesterdays_impressions,todays_clicks as yesterdays_clicks from todays_links
<1> liil what error did you get
<0> gets col count does not match value count
<1> cyberic your're still missing your zero placeholders
<0> oops
<1> sharmaa if you want to specify your p***word on the command line don't leave a space after the -p
<2> then of gcc test.c -g -c
<2> the error: stlib.h don't exist the file or don't exist the directory....and then gcc test.o -L/usr/local/mysql/ib -lmysqlclient -lz -o test
<2> the error is: test.o the file or directory don't exist
<4> hi, can i have a cost idea please, i am working with mysql and php, but now it's the first time i will worked on a search engine application
<0> hehe, its alive :D
<4> i have to manage 8 tables, administaion form and more than 20 queries by session
<0> now I just gotta get my population code to work
<0> thanks for all the help bobfield
<1> np cyberic you're welcome
<1> stdlib.h is a standard header in the standard location
<2> yes
<2> mm....i have to install ODBC maybe?
<5> hi
<2> yes, n?
<1> odbc has nothing to do with the mysql c api
<1> you just put in #include <stdlib.h> right?
<5> could anyone possibly help me with a mysql search query? I'm getting the error "#1191 - Can't find FULLTEXT index matching the column list"
<1> slazereth, what's your query look like?
<5> SELECT *, MATCH (first,last) AGAINST ('Britt') AS score FROM models WHERE MATCH (first,last) AGAINST ('Britt') ORDER BY score DESC, last ASC, first ASC
<5> if I drop the match down to just one of the columns (either first or last) then the query goes through
<2> #include <stdlib.h> have i in my test.c
<5> but it doesn't work if I try to use both of the columns at once.
<1> do you have a fulltext index that spans those columns?
<5> ahh, that's the problem. I just had INDEX. not FULLTEXT
<5> heh stupid mistake
<5> thanks bobfield!
<1> liil does /usr/include/stdlib.h exist?
<1> slazareth you're welcome
<0> what did you mean my zero place holders?
<1> well you have 2 fields you wanted poplulated with a zero
<1> so the field list in parens lists those 2 fields
<1> in the select field list, need to place zeroes in matching spots
<0> I am having problems on this one:
<0> insert into todays_links (id,todays_impressions,todays_clicks) select id from link_pool where rotated=0 order by rand() limit 35
<0> link_pool has a total of 8 cols
<0> and I only need the id out of it
<1> still you need two more fields in the select field list to match
<0> to just place the zeros there?
<1> or don't list those other two fields at ll
<6> bobfield, your back
<1> at all
<0> ok
<2> bobfield don't exist
<6> can you give me a shout when you have 5 minutes please
<6> no rush
<0> got it
<1> sure thing ikonia
<0> thanks very much again
<6> thanks
<1> anytime cyberic
<1> ikonia what'cha got
<0> i know I am a pest, but I just remebered this: I also need to update the rows affected by the last query so that rotated=1 can i do that within the same query?
<0> maybe with a subquery?
<1> sure cyberic list rotated in the parens, add 1 as rotated to select field list
<0> ok
<0> thanks
<6> bobfield hey, its just a continuation from the help, well work you did for me last night
<6> as you pretty much did it all
<6> I left your procedure running for 8 hours last night and it never came back
<6> which makes me thing either the loop is wrong
<6> or the logic behind it is wrong
<1> oopsy
<1> hmm
<6> I've tried it on 2 smaller databases
<6> for a quicker test
<6> and it never returns
<6> I see the initial "kick off"
<6> in the mysql log
<6> but no sql ever gets p***ed through the log
<1> how does it work without the loop?
<6> well to be honest, I've not tried it
<6> as I wanted to talk it through with you the creator
<1> ah
<6> as the procedure was out of my mysql limits
<6> if you have some time I'd appriciate walking it through with you
<1> sure I've got time
<6> cool
<6> thanks
<6> my thoughts behind it
<7> hello, does anyone know how i can drop all tables wie the prefix g2_?? i tried "DROP TABLE LIKE 'g2_';" but this didn't work
<6> is the data
<6> in that you've not accounted for the data in the row
<6> so the logic is flawed
<6> as I may have explained it bad
<6> the field I'm trying to strip contains a full html page - just just the tags, its the full html page
<6> so there could be say 8 <font> tags in each row
<6> or none
<6> which I don't think I explained well last night
<1> I've stripped html before but usually use C
<6> yes, its tough doing it at the db level
<6> your actual code looks fine (when I work it through slowly)
<1> could write a udf in C
<6> its more a case of the logic and how it handles the data
<6> (in my opinion)
<6> bobfield - as it stands, I'll take any options
<1> true it's hard to have any sort of detailed logic
<6> I've tested my problem against a font free row
<6> but I need to test it against m*** records
<6> to see if I'm right
<1> yes certainly you need some easy test case rows
<6> well, I've tested against say 3 or 4 individual rows
<6> but when there are 2000+ records that doesn't really account for all the html variations
<6> so I need to strip all records
<6> and run my css tests against html without <font> tags
<6> rather than just say 10 random rows
<1> maybe a job for perl but that's out of my league
<6> the stripping is not "that" hard
<6> its how to strip from the database
<1> or code a small c program that calls the mysql C api
<6> thats why I was looking at doing it in sql its self
<6> could you hand hold me through running your sql say against 3 rows
<8> is creating an index on a varchar(60) more effective than defining the length of a tinytext to (60) and creating an index on that?
<6> just to see what it does properly
<6> i'll drive if you oversee
<1> sure
<6> cool, let me get an xterm up
<1> brb for a sec
<6> ok
<1> back
<1> (Coffee)
<6> ok - I'm connected to the database
<6> if I
<6> update content
<6> set content = concat(LEFT(@string,@pos:=locate('<font',@string)-1),RIGHT(@string,length(@string)-locate('>',@string,@pos)))
<6> where rowid = 2
Return to
#mysql
or
Go to some related
logs:
nforbes
headmonkey 18
backtrack broadcom bcm43xx
create zone files from database
javasan
ICY 404 Resource Not Found icy-notice1 in php
suckerfish fails on IE 7 beta 3
#web
averatec compatibilities
#oe
|
|