Search DaniWeb - concat

Claude 3 Opus Vs. Google Gemini Vs. GPT-4 for Zero-Shot Text Classification 1 Month Ago by usmanmalik57 …(n=33) # Concatenate the samples into one DataFrame dataset = pd.concat([neutral_sample, positive_sample, negative_sample]) # Reset index if needed dataset.reset_index(drop… Re: Concat is not working in inclause 8 Years Ago by pritaeas `CONCAT` is a string function, am surprised you even get that one row. The query you get is: select c_id,c_name from category where c_id in ('870,854'); My guess is that the string is being casted to an int again, resulting in 870. concat 13 Years Ago by nHulk …"); String year=request.getParameter("year"); how to concat these three parameters ... Re: concat 13 Years Ago by nHulk String month=request.getParameter("month"); String date=request.getParameter("date"); String year=request.getParameter("year"); plz tell me how to concat these three parameter in to date format(year-month-day) !!! so that it is easy to insert date value in data base... Re: concat 13 Years Ago by nHulk …" them one after the other.[/QUOTE] i want to concat those three parameters in date format(year-month-day) so… concat in trigger, unexpected behavior 13 Years Ago by dkaptain … IF; IF NEW.checked_out_time IS NOT NULL THEN SET `checked_out_time` = CONCAT('\'' , NEW.checked_out_time , '\''); ELSE SET `checked_out_time` = 'NULL' ; END IF;… all the variables into a usable insert statement SET sqlVariable = CONCAT( 'INSERT INTO jos_weblinks VALUES (' , `id`, ',', `catid`, ',', `sid`, ',', `title`, ',', `alias`, ',',… Re: concat in trigger, unexpected behavior 13 Years Ago by dkaptain I hope it's not bad form to answer my own question. I still don't know why setting a variable using CONCAT to add single quotes doesn't work. I did however manage to get the results I wanted. I added the quotes when I create sqlVariable near the end of the script. I will mark this solved since my script now works. Concat values from same column with different conditions 10 Years Ago by saadi06 …,value. Now I want to make a query that should concat value with different nr. I have tried this syntax but… it is not working. SELECT CONCAT((SELECT value FROM table WHERE history_nr=63 and id=1… Re: Concat values from same column with different conditions 10 Years Ago by saadi06 The data that is to be displayed is height like 5ft 2 in.How can I show this using group concat concat mysql question 15 Years Ago by lacompsr … cant get it working ive got this so far: SELECT CONCAT('<a href="localhost/upload/dltest.php?id=',id… Concat is not working in inclause 8 Years Ago by s.ganesh …> select c_id,c_name from category where c_id in (select concat(870,',',854) as c_id); +------+---------------+ | c_id | c_name | +------+---------------+ | 870 | Telugu Events | +------+---------------+ Please… Re: Concat is not working in inclause 8 Years Ago by pritaeas Yes, it's possible, but I recommend using the first one. This should work I think: SELECT c_id, c_name FROM category WHERE FIND_IN_SET(c_id, (SELECT CONCAT(870,',',854) AS c_id)) Concat multiple rows into single row in DB2 7 Years Ago by xuexue … MyCol1 FROM MyTable WHERE MyCol2 = ParCol2 DO SET ReturnVal = ReturnVal Concat CsrC1.MyCol1; END FOR; RETURN LTRIM(ReturnVal); END ; and call… Re: Concat multiple rows into single row in DB2 6 Years Ago by Nate_3 What exactly are "You" trying to concat? What does your table look like? Re: concat 13 Years Ago by masijade Why do you want "JSP coding", when you're currently using Java coding? Don't tell me you used a scriplet to get those values. Don't tell me that you don't know about ${param.xxx} JSP syntax. Why does everybody dive immediately into JSP and [i]never[/i] look at the tutorials? [url=http://download.oracle.com/javaee/1.4/tutorial/doc/]The… Re: concat 13 Years Ago by masijade [code]String bogus = year + month + date[/code] Re: concat 13 Years Ago by nHulk [QUOTE=masijade;1534987][code]String bogus = year + month + date[/code][/QUOTE] String date=year+"-"+month+"-"+day; is it correct ??? Re: concat 13 Years Ago by masijade Did you [i]try[/i] it? Aside from the fact that you should be using PreparedStatement, create an actual Date object from that info, using a Calendar instance probably, and then using PReparedStatements setDate, but judging by the rest of tall this you are already in over your head and have no interest in learning how to do anything [i]properly[/i… Re: concat 13 Years Ago by nHulk [QUOTE=masijade;1535011]Did you [i]try[/i] it? Aside from the fact that you should be using PreparedStatement, create an actual Date object from that info, using a Calendar instance probably, and then using PReparedStatements setDate, but judging by the rest of tall this you are already in over your head and have no interest in learning how to … Re: concat 13 Years Ago by nHulk [QUOTE=masijade;1535011]Did you [i]try[/i] it? Aside from the fact that you should be using PreparedStatement, create an actual Date object from that info, using a Calendar instance probably, and then using PReparedStatements setDate, but judging by the rest of tall this you are already in over your head and have no interest in learning how to … issue with using local-name with concat in a predicate 14 Years Ago by tadchristiansen …select="local-name()" /> ANSWER[@id = concat($prefix,'_STYLE')]/@valueSrc[/CODE] It works just fine. I… worked fine as well: [CODE]ANSWER[@id = concat(concat('DE','CK'),'_STYLE')]/@valueSrc[/CODE] Does anyone have any… ideas on why: [CODE]ANSWER[@id = concat(local-name(),'_STYLE')]/@valueSrc[/CODE] doesn't return a… can i update variable using concat and for-each? 15 Years Ago by micksatana … /> <xsl:variable name="strTest" select="concat($strTest, '/', $tmp)" /> </xsl:for-each>…; <xsl:variable name="strTest" select="concat($strTest, '/')" /> <xsl:value-of select…result will be /01/02/ i also try recursive concat using xsl:template, but that make me even more… Can we use query in Concat 11 Years Ago by saadi06 …a question that can we use a mysql query in Concat clause. I want to make a query like this… SELECT CONCAT(AVG(value),'-',(select Count(UserId) as counts from user_details )) …surveyuseranswer Now I want to count number of users and concat it with the average value. My query runs but … variable concat and exec cmd question 14 Years Ago by k2k basically i need to have 2 variables.. concat them and put them into use. here is what i … = '9.34.120.36'; #$com = $client_1.$stats; #print $com; the concat here looks fine... system ("scp $client_1.$currentTranStats ."); [/code… string concat w/o strcat(),strlen() 13 Years Ago by madval88 …++[/ICODE] it obviously will give an error. [CODE] //includes void concat(char * dest, const char * src) { while (*dest) ++dest; while (*…dest++ = *src++); } void main(){ concat("hi","hello"); getch(); }[/CODE] The only… Re: string concat w/o strcat(),strlen() 13 Years Ago by madval88 …++[/ICODE] it obviously will give an error. [CODE] //includes void concat(char * dest, const char * src) { while (*dest) ++dest; while (*…dest++ = *src++); } void main(){ concat("hi","hello"); getch(); }[/CODE] The only… Re: string concat w/o strcat(),strlen() 13 Years Ago by Ancient Dragon …-only memory. What you have to do is below. Your concat() function should work ok as you wrote it. [code] int… main() { char s1[255] = "Hello "; concat(s1,"World"); } [/code] >>there must be… select update concat in one query?? newbie 11 Years Ago by bluecloudburst … been reviewed by specific admins? Saw a post about using CONCAT and COALESCE, since the 'reviewedby' field will be null at… applicants WHERE user_id = {$_GET['uid']}; UPDATE applicantsGII SET applicants.reviewedby = CONCAT(COALESCE(applicants.reviewedby,''),"$_SESSION['user_id']")"; group or distinct concat alias result to one column mysql 10 Years Ago by bumbumpaw … prod VARCHAR(70)) BEGIN SET @sql = null; SELECT GROUP_CONCAT(DISTINCT CONCAT( 'max(case when Attribute = ''',Attribute,'" Then p.Attributevalue end…) as `',Attribute,'`' ) INTO @sql FROM tblAttribute; SET @sql = CONCAT('Select pr.product, ',@sql,' from tblproduct tblproduct pr LEFT JOIN… Re: select update concat in one query?? newbie 11 Years Ago by urtrivedi $query="update applicants set applicants.reviewedby = CONCAT(ifnull(applicants.reviewedby,''),".$_SESSION['user_id'].") where user_id={$_GET['uid']}";