Programming & Design - January 2007

Lets say I have 2 tables one called EMP_INFO and another called ACTIVITY linked one to many by EMP_INFO.EMP_ID to Activity.EMP_ID. I want to return all the employees with there info and the last time they logged on. Assuming that I want to pull all the empoyees info and only the greatest value of logged_on for each employee how can this been done. I triend
"select emp_info.*, max(activity.logged_on) from emp_info join activity on emp_info.emp_id = activity.emp_id" but that is not accepted because max(activity.logged_on) is just wanting to pull the largest value on logged_on and not the largest value for logged_on for each employee in emp_info. How can this be re-wrote to work?

2007-01-10 06:24:31 · 2 answers · asked by csdraska 1

Can someone help me out with some good info. I want to take these courses.

Active Server Pages
C Programming: An Intro
C++ Programming
C# Programming
ColdFusion
ColdFusion Professional:
for Developers
Crystal Reports
DHTML: Cross-Browser
Techniques
Domino: Application Dev.
Domino: Web Programming
Dreamweaver UltraDev
Web Pages with JavaScript
Fund. of Computer Program
HTML: Web Authoring
Java Programming
JavaScript Cookbook
Microsoft SQL Server
System Administration
Object-Oriented Programming:
Principles
Optimizing Web Site Perf.
Oracle Dev: PL/SQL
Oracle Fundamentals
Oracle: PL/SQL
Oracle: SQL *Plus
Oracle: SQL, PL/SQL, and
SQL*Plus
Oracle: Tuning and
Troubleshooting
Relational Database Design
SQL Server: Design and
Implementation, Part 2
SQL: Advanced Querying
SQL: An Introduction
SQL: Fund. of Querying
VB Script
Visual Basic
Visual C++: Desktop Apps
Visual C++: Distributed
Applications
Web Development with
Cascading
Style Sheets
XML:

2007-01-10 06:18:12 · 4 answers · asked by SALLY 2

I have a report that I believe was created using Visual FoxPro. There seem to be four associated files, nonp.frt, nonp.frx, nonp.fxp and nonp.prg.

The text I need to change is in nonp.frt. I made a backup copy and tried changing it with Notepad, but that made the file unusable. As a test, I opened a fresh copy with Notepad again and saved it without making any changes at all, and it still corrupted the file.

Is there a way to edit the text in this report without corrupting it or shelling out for developers software?

2007-01-10 06:15:00 · 5 answers · asked by bleme 4

In Microsoft Visual Basic how do I include an image that then can be changed like with a list of images?
Please give code or relevant link.

2007-01-10 06:14:12 · 2 answers · asked by sbraidley 3

I am using PHP to make a Full-Size Image display page. I'm not using any fancy PHP callup script because everything I have is integrated with SQL. I'm using SQL to just simply execute nothing but the URL of the image that is requested by using WHERE id= and then a GET command for "id" in the address bar.

Thus, in the end, how this would work is the script executes the URL of the image, and then I have on a separate php page, the tags for "> That would work right? And be since the something.php only executes the image URL?

I get the error that there was an unexpected { curly bracket in the area of my while($row) fetch blah blah blah stuff is. Anyone know what the problem is there? I know the syntax is right, so no need to include that code.

2007-01-10 06:12:30 · 2 answers · asked by ? 3

hello,can anybody please show me how to do this:

*
**
***
****
***
**
*

2007-01-10 06:02:52 · 2 answers · asked by trickyme 1

I have real player and windows media player (I'm not exactly sure what or if I have flash player) but when I try to play or watch something it is very choppy (starts and stops, no flow). Too often, just opening a web page is difficult and takes forever depending on if there's advertisements etc.

2007-01-10 05:57:57 · 4 answers · asked by Mr. Incredible 1

Context:

"SELECT /*+ full(T1) parallel(T1,6) */
distinct t1.con_row_id,
t1.acs_id,
t1.lastname,
t1.firstname,
t1.contact_type,
t1.addr_row_id,
t1.pr_addr_id,
t1.in_care_of,
t1.form_in_care_of,
t1.location,
t1.migration_code
from TEMP_ICO_FINAL t1
where t1.con_row_id != 'DUMMY'
and t1.contact_type != 'DUMMY'
and t1.addr_row_id != 'DUMMY'
and t1.acs_id != 'DUMMY'
and t1.in_care_of is not null;"

2007-01-10 05:57:40 · 10 answers · asked by Anonymous

2007-01-10 05:55:11 · 2 answers · asked by Anonymous

That will allow you to take a number of scanned pictures and make them into 1 picture. Like a collage of Pictures but on 1 image?

Any help would be extremely grateful, thanks.

2007-01-10 05:53:16 · 2 answers · asked by Sally H 3

need info on creating email addresses with my domain name

2007-01-10 05:51:28 · 3 answers · asked by EESC 1

its PHP & I cant do it to save my life, I am willing to pay, please IM ASAP

2007-01-10 05:39:37 · 2 answers · asked by Anonymous

I want to buy a good book on ASP.NET using C# 2003(v1.1) which uses IIS not wrox.........can u suggest a good one....and its price if knowing......

e-book is also helpfull.....

Can u suggest a site for tutorials for ASP.NET using c# 2003...

2007-01-10 05:31:19 · 3 answers · asked by roni 1

2007-01-10 05:29:41 · 19 answers · asked by T rg 2

I want to write a how-to and post it on my company's sharepoint website...how do i get the rich text editor to show the code as-is? It currently breaks the format if i try to paste a snippet.

2007-01-10 05:27:48 · 1 answers · asked by Erik P 1

Hi there.

I have two domains: domain1 and domain2 which are at /var/www/html and /var/www/html2 accordingly
the .htaccess in /var/www/html2 did not work so I added this to my httpd.conf: http://apache.pastebin.ca/312138
now the original problem is solved.. but domain1 now redirects to domain2 whenever I type the URL...

Any ideas?

Thanks.

2007-01-10 05:07:08 · 1 answers · asked by Anonymous

I need a web hosting company that has *servers in India*. I asked this question before, didn't get the useful answer. Most of the web hosting sites I came across have offices in India, but servers in U.S.

Do you know of any web hosting company that has server in India? I know of two companies rediff and Net4. Rediff is my competitor, so I don't want to host there. Net4India is very expensive for what they offer. I would appreciate if you can give me some pointers on this topic.

Thanks!

2007-01-10 05:06:04 · 8 answers · asked by MRM 2

I am trying to create a 2D array of 3x3 using a single dimensional array starting from 1-9. 3 rows and 3 cols but the array is single dimensional. [1,2,3,4,5,6,7,8,9] but i am trying to represent it as :
[1,1 (1)] [1,2 (2)] [1,3 (3)]
[2,1 (4)] [2,2 (5)] [2,3 (6)]
[3,1 (7)] [3,2 (8)] [3,3 (9)]

The user only enters the rows and cols and the grid is fixed 3x3.
How can i calculate for example:

r2, c2 = 5?

if i do this r*c then i get the correct answer for 1*1, 1*2, 1*3, 2*3, 3*3 but not for others.

Thanks everyone

2007-01-10 05:03:37 · 3 answers · asked by Manish 5

I want to use a link to a PDF in my e-mails. I have published several to the web using msn groups and yahoo geocities, however when my customers click on the link in my e-mail, they must also be a user to view the PDF. Please help! I just want the link to open immediately!!

2007-01-10 05:03:19 · 1 answers · asked by Les 2

2007-01-10 05:02:56 · 1 answers · asked by Anonymous

Is there anyone out there willing to make me a logo for free? I know what i want and the colors and stuff, but I don't know how to do it myself and I was wondering if there was a kind hearted person out there that would do it for me. Let me know. Hope to talk to someone soon, you can email me also or IM me on yahoo mess. My email is Shermia.trueheart@yahoo.com or my IM is Shermia.trueheart

2007-01-10 04:31:19 · 2 answers · asked by Anayden 4

I'm new to C ++ and Need help on this problem:

Design an algorithm ot find the weighted average of four test scores.
the four test scores and their respective weights are given in following format:

Testscore1 Weight1
...

For example, a sample data is as follows:

75 0.20
95 0.35
85 0.15
65 0.30

Forgot to mention it has to be done in Pseudocode.

2007-01-10 04:15:19 · 3 answers · asked by octax2 1

how do i copy some one elses picture??
is there a code for there pic??

2007-01-10 04:13:07 · 1 answers · asked by Ms. Weequahic high 3

I need some help with my visual basic program I would like to to reboot the computer when the user clicks a button but cant get it to work, this is what ive got so far (that dosent work):

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Shell("RUNDLL32.EXE shell32,SHExitWindowsEx 2", AppWinStyle.NormalFocus)
End Sub

RUNDLL32.EXE shell32,SHExitWindowsEx 2 is meant to reboot the computer (someone told me) but it just dosent work so does anyone know how I can do it?

2007-01-10 04:11:17 · 2 answers · asked by sbraidley 3

2007-01-10 04:04:39 · 4 answers · asked by Dutch 4

If so which of the following would be true?

a. head and title
b. head and body
c. head and text

Or none of the above?

2007-01-10 04:02:22 · 7 answers · asked by Ahhhhh 1

I want to make a report in Visual Basic. But I do not know the number of columns at design time as it will be created druing run time.To be more specific, I want to display the marks of students in a row but there are different subject is the class with options.The classes may have any subject and I have to display all in a line.

2007-01-10 04:01:25 · 3 answers · asked by rohit 1

I'm programming with visual basic, but I don't know if its possible to do a random variable. I want to be able to randomly choose a value for a variable and then use the value to choose one out of two possible message boxes to pop up afterward.

2007-01-10 03:56:29 · 2 answers · asked by Sebastian 1

How do I make the slide bigger because I need to write a lot of information about the show?

2007-01-10 03:25:00 · 3 answers · asked by Anonymous

I am learning php and have sent out some emails this way but I need to add images and things to it. Is this possable?

2007-01-10 03:12:25 · 3 answers · asked by Bates Water Gardens 4