Tagged questions

15 results found

Crystal Reports XI -- prompt for "Order By" ?August 16, 2011

How can I change the below in Crystal Reports XI so user get prompted for a "Order By" that makes them pick one of the below methods ?  Method #1 = by SHIPMENT_VALUE  Method #2 = b

24

views

0

votes

7

answers

Mysql select more if not enoughAugust 16, 2011

Hello experts, I have to populate an advertisement column in my site. I'm using full text with match-against to search for tags. That works fine, but if I get less than 2 rows I want to search the

19

views

0

votes

4

answers

SQL2008R2  ORDER BYnot workingAugust 16, 2011

Hi All, I installed over the weekend SQL 2008R2 Express. I imported a table tblabbreviations (ID, Abbreviation (nvarchar(10), Description Nvarchar(50). Afterwards I added some records and created a ne

18

views

0

votes

5

answers

order by before preforming mysql query?August 16, 2011

Here's an odd question.. I have some code that was written for me that lists a manufacture name from a table , but it's doing it in order of manufacturer_id instead of manufacturer_name, this

24

views

0

votes

5

answers

Using ORDER BY RAND() with WHEREAugust 16, 2011

Hi guys, I'm new to Expert Exchange :D I have average PHP skills (and still learning) but very low Mysql skills.  And really need help with this new project I've taken on. What I need to

23

views

0

votes

23

answers

ORDER BY clause for FormsAugust 17, 2011

Hi, I created a form using the wizard and I believe it's based on one the queries I created. I can't really recall as I'm just learning access. In the query I added an ORDER BY clause and

22

views

0

votes

6

answers

MySQL Union with Order By and LimitAugust 17, 2011

If I have two select statements and use union to join them where is the best place to put order by and limit. For example: ( select * AS alias_names FROM T1 ) UNION ( select * AS alias_names FROM T2 )

20

views

0

votes

5

answers

Help with MYSQL Query. ORDER INNER JOIN UPDATEAugust 17, 2011

I have an sql query: UPDATE am_actinic INNER JOIN (SELECT t1.offer_id,     (SELECT FLOOR(COUNT(offer_id) / 10) + 1 desired_page FROM am_actinic t2 WHERE t1.offer_id < t2.offer_id AND t1.s

21

views

0

votes

7

answers

mySQL :: Order By Date / Time ::August 17, 2011

Okay, working on a project that has a different timestamp than the standard mysql timestamp. Format: 03/11/2009 at 10:24:12 AM I need to have it so the latest Date/Time shows on Top. SQL: SELECT Date,

20

views

0

votes

15

answers

ORDER BY DATE ASC is sorting alphabetically and not by date.August 17, 2011

I have a select query as shown below where i am grabbing a date from a table and formatting so that it displays in a friendly way. I need the data to ORDER BY DATE ASC. Trouble is, when I apply the fo

23

views

0

votes

2

answers