Search Results

Search found 33382 results on 1336 pages for 'end tag'.

Page 719/1336 | < Previous Page | 715 716 717 718 719 720 721 722 723 724 725 726  | Next Page >

• sql query help join (i think)

  - by milan

  I am having trouble figuring our how I can get results only when products.published, product_types.published, and product_cats.published = 1 but my query isn't working. Please help: SELECT `products`.`title`, `products`.`menu_id`, `products`.`short_description`, `products`.`datasheet_icon`, `products`.`datasheet`, `products`.`ordering`, `products`.`product_type_id`, CASE WHEN CHAR_LENGTH(`products`.`alias`) THEN CONCAT_WS(':', `products`.`id`, `products`.`alias`) ELSE `products`.`id` END AS slug FROM `products`, `product_cats`, `product_types` WHERE `products`.published=1 AND `product_cats`.published=1 AND `product_types`.published=1 AND `products`.`product_cat_id`='42' AND `product_types`.`id` IN (1,40,48,49,50) GROUP BY `products`.`id` ORDER BY `product_types`.`ordering`, `products`.`ordering`

  Read the article

• [MYSQL] select statement that combines similar rows with certain ids ?

  - by vegatron

  hi I have a warehouse_products table which defines how many products in the warehouses so lets say I have 20 records/rows in the table, some rows may contain the same product id but in a different warehouse I need to create select statement that give every product one row, and in this row I must have the quantity in warehouse A and warehouse B .. so in the end I will get for example 10 rows that contain all the data id domain_id warehouse_id wh_product_id quantity 2 1 2 2 84 3 1 1 3 221 4 1 3 3 0 5 1 1 3 14 6 1 1 2 73 7 1 1 1 123

  Read the article

• How can I recognize a generic class?

  - by serhio

  How can I recognize (.NET 2) a generic class? Class A(Of T) End Class ' not work ' If TypeOf myObject Is A Then ?

  Read the article

• Invalid attempt to access a field before calling Read() INSERT

  - by Raphael Fernandes

  I'm trying to use this code to check if the system already exists a field with this value Dim adap As New MySqlDataAdapter Dim sqlquery = "SELECT * FROM client WHERE code ='"+ TxtCode.Text +"'" Dim comand As New MySqlCommand() comand.Connection = con comand.CommandText = sqlquery adap.SelectCommand = comand Dim data As MySqlDataReader data = comando2.ExecuteReader() leitor.Read() If (data(3).ToString) = code Then MsgBox("already exists", MsgBoxStyle.Information) TxtCode.ResetText() TxtCode.Focus() Else Console.WriteLine(insert("INSERT INTO client (name, tel, code) VALUES ('" & name & "', '" & tel & "')")) con.Close() End If

  Read the article

• Stuck. I need some VBA code to insert double-quotes around strings in each cell in an excel range.

  - by cmm

  I'm familiar with VB.NET, but VBA in excel has me stumped. With my best attempt, I get a "Type mismatch" error: Sub AddQuotes() For Each x In Range("List").Cells x.Text = "*" * " & x.text & " & "*" Next End Sub

  Read the article

• In a MySQL SELECT query, can I use my "AS column" in a WHERE specification?

  - by user556352

  In my database I calculate distance between nodes with: SELECT DISTINCT dest.name, AsText(orig.location), AsText(dest.location), round((glength(linestringfromwkb(linestring((orig.location), (dest.location)))))) as distance FROM nodes orig, nodes dest WHERE orig.name='GERP' I would like to add "and distance < dest.visibility" at the end, but am told that distance is an unknown column. Any insight very much appreciated.

  Read the article

• How to print value of a variable (which can be "-n" or "-e") in bash?

  - by Vi

  How to print "-n", "-e" or "-neeenen" from bash (without a newline at the end, without invoking of external programs)? Q="-n" echo -n "$Q" # fail echo -- "$Q" # fail cat <<< "$Q" # fail, also starts external program printf -- '%s' "$Q" # success, but starts external program

  Read the article

• In "git checkout -- files", what does "--" mean?

  - by e-satis

  Is it the "end of option" I am used to see in bash (and if yes, why do we use it) or is it a Git notation for the Index or the HEAD?

  Read the article

• how to read the contents of a file In Erlang ?

  - by Zubair

  I know you can do something like this: readlines(FileName) -> {ok, Device} = file:open(FileName, [read]), get_all_lines(Device, []). get_all_lines(Device, Accum) -> case io:get_line(Device, "") of eof -> file:close(Device), Accum; Line -> get_all_lines(Device, Accum ++ [Line]) end. : Is there a one liner BIF that can do this too?

  Read the article

• read, parse and process json (java)

  - by mac

  Guys, simple situation - read a json file discover all key-value pairs compare key-value pairs I tried gson, package from json.org, but can't seem to get far with it. Can someone please provide a clear sample in Java on how to take a file, read it, end up with json objec i can get key/value pairs from thanks so much

  Read the article

• Help with manipulating some strings.

  - by Alex

  My strings are of this kind: City (PR) from a Database, where PR stands for Province. At the end I want two separate variables. City and PR. I have to do this with C#. Any idea? Thanks.

  Read the article

• Adding an ID or Class in Ruby on Rails?

  - by Probocop

  I've got the following code for a search form, but how would I add an ID or a class to the submit button? <% form_tag '/wine/search/', :method => 'get' do %> <%= label_tag "Search" %> <%= text_field_tag :search_string, params[:search_string] %> <%= submit_tag "Go" %> <% end %> Thanks

  Read the article

• Write an assembly program to input keystrokes from the PC’s keyboard and display the characters on t

  - by J-MO

  Write an assembly program to input keystrokes from the PC’s keyboard and display the characters on the system monitor. Pressing any of the function keys F1-F10 should cause the program to end. I have no idea how to write this code, and need some help por favor.

  Read the article

• mysql query problem

  - by PiePowa

  hey everybody i'm trying to do somthing simple like this SET i = 0; WHILE (i <= 2230686) DO INSERT INTO customers(check) VALUE(0); SET i=i+1; END WHILE; in the phpmyadmin SQL query box and it doesntwork and the mysql doesnt throw an understandable reason any clues ?

  Read the article

• PHP number range menu from array

  - by Julious

  Hello people! I'm a bit confused here. I have a php array like this Array(2010,2009,2008 ...1992) and i want to create a loop to print a menu with a four year range counting down like this 2010-2006 2005-2001 2000-1996 etc.. How can i do this Everything i tried end up in an endless loop. THnx in advance. J.

  Read the article

• Removing &NBSP; in Rails

  - by Trip

  I am trying to remove all &nbsp;'s in my model with the following method : def about_us_sans_spaces self.about_us = replace(self.about_us, "&nbsp;", " ") end Except! it turns out 'replace' isn't a method in rails. How would you remove the  s? Mind you, I have already tried sanitized, simple_format. My view looks like this right now: = truncate(sanitize(simple_format(organization.about_us_sans_spaces), :tags => ''), 125).titleize

  Read the article

• Use a specific database depending on condition

  - by nimo

  Can I somehow use a specific database given a specific condition? To clarify I will give a naive example: CASE WHEN @dbnum = 1 THEN USE Db1 ELSE USE DefaultDb END

  Read the article

• PHP Time Remaining in Current Day

  - by Ajith

  How can we find out how many time remains to end the current day from current time[date('Y-m-d H:i:s')] in PHP.

  Read the article

• Oracle/SQL table attribute question

  - by UnceRawr

  I have been given a context schema for a database i need to make for my coursework but some of the attributes (column names) contain letters in brackets at the end of them such as: *x_Number (Adm) *x_Number (A) *x_Number (P) The problem is i have no idea what these letters mean! Can anyone help?

  Read the article

• MySQL Can't Handle Parameters for Stored Procedures

  - by Takkun

  I'm trying to make a stored procedure but it doesn't seem to be recognizing the parameters I've given it. Procedure create procedure test_pro(IN searchTable VARCHAR(55)) begin select * from searchTable limit 10; end // Trying to execute mysql> call test_pro('exampleTable'); ERROR 1146 (42S02): Table 'db.searchTable' doesn't exist It isn't replacing the searchTable with the parameter that is passed in.

  Read the article

• C++ sort method

  - by qwead

  I want to sort a vector using std::sort, but my sort method is a static method of a class, and I want to call std::sort outside it, but it seems to be trouble doing it this way. On the class: static int CompareIt(void *sol1, void *sol2) { ... } std::sort call: sort(distanceList.at(q).begin(), distanceList.at(q).end(), &DistanceNodeComparator::CompareIt); Shouldn't it be possible to do this way?

  Read the article

• How to use an excel data-set for a multi-line ggplot in R?

  - by user1299887

  I have a data set in excel that I am trying to create a multiple line plot with on R. The data set contains 7 food groups and the calories consumed daily associated to the groups. As well, there is that set of data over 38 years (from 1970-2008) and I am attempting to use this data set to create a multiple line plot on R. I have tried for hours on end but can not seem to get R to recognize the variables within the data set.

  Read the article

• designing the database if depending on dynamic columns

  - by phani_yelugula

  In my project,"admin" can create text fields dynamically (using jsp +javascript) and enter can enter data in text fields for saving.in the back end i have to save them in database. here the problem is 1)how we can create columns dynamically depending on the textfields admin is creating. like if he is creating 5textfields then we should create 5 columns in database,if he going with 10 we should do 10 columns. im doing this in mysql,jsp,struts,hibernate

  Read the article

• get images from url and retrieve them all to select the one which is the biggest

  - by daniel

  So i want to open a URL and regex all the image urls from the page. then i want to curl all of them and check what size they have. in the end i want to get the biggest one

  Read the article

• exceptions in C++

  - by helloWorld

  I have some techniacal question, in this function: string report() const { if(list.begin() == list.end()){ throw "not good"; } //do something } if I throw exception what is going on with the program? Will my function terminate or it will run further? if it terminates, what value will it return?

  Read the article

< Previous Page | 715 716 717 718 719 720 721 722 723 724 725 726  | Next Page >