Guys, please help me design a databse to hold test cases.

I'm really stuck at the minute.

Can someone help me with the cardinality constraints? E.g. 1:1, 1:N, M:N...

Can someone even help me decide on the realtionships between each table?

Hey Guys,

I was hoping someone could help me with designing a database?

Basically, I want to design a database that will hold a bunch of test cases. For those of you that don't know, a test...

Hmm I'd really prefer to write teh code myself as it is for a client.

Is there any other way, maybe a tutorial? Or maybe another language would let me write code to do this?

Thanks for your...

Hey guys

I was hoping someone could shed some light on some research I'm doing.

Basically, I want to know if I can use PHP to read n number of cells from an excel file. Based on each cells...

sorry, its not the upload im worried about. its after the upload. once a file is uploaded, i want the file to undergo some processing. thing is, i dont want the usert to have to wait for the file to...

Hey Guys,

I was hoping someone could tell me how to run server side code to process a file?

Basically, I want users to upload a file to my site, and once the file is uploaded, I want server...

Hi Guys

I'm having a lot of bother trying to execute a vbs script from an asp file.

Basically, what i want is for the asp to call a vbs file, and then i want the vbs script to write to a file...

that wouldn't run, saying it wasnt a group by, so i added the date and time to the group by, and when i ran it, i didnt get any results back, just an empty result set

thanks for your time!

Hey guys

I have a table, that lists people, with a correpsonding date and time for each activity. My structure is like:

PersonID......Date............Time
872367.........01/01/08......15:00:00...

Hey guys,

say im doing a query like:

select * from info where date = '21-APR-08'

but i want to do it for a number of different dates, how can i create an array to hold teh dates, and then...

um i dont know what that means, but i dont need to do that anymore, but thanks for you help!

Hey guys

I have a current query that looks something like:

select a.avalue, b.bvalue, c.cvalue from

(select idVal, dummyVal as avalue from....) as a

left join

what if i want to execute sql queries and pull them back to the php file so i can display the results on a web page?

thanks very much for your help!

yeah that would be great, do i ahve to download any additional software to connect to the oracle db?

Hey guys, can someone please tell me how I can connect to a remote Oracle DB using WAMP (Windows Apache MySQL PHP) installed locally on my machine?

Hey Guys

So in my work, I create an excel spreadsheet. The spreadsheet has cells with hyperlinks in them. When clicked on, the user is taken to another cell within the spreadsheet. Sort of like an...

has anyone else on this forum had a similar problem in the past?

if i do a distinct count on run ids where status = passed, i get the correct number of passes, and its the same for fails, its...

Here is a brief overview of the table structure, and some rows of some columns for each table in use:

ERROR____________LINK_______________TESTCYCL________RUN
BG_ERROR_ID ------>LN_ERROR_ID ...

Hey tesu,

thanks very much for your reply, I really appreciate your time! :D

How would I go about applying post #7 to my problem? Would I need to use the with statement to create a temporary...

Can anyone help me please?

If it helps, I was thinking, I'd just have to strip the table down by listing distinct RUN.CY.RUN_ID's , and from the new table containing only distinct RUN.CY.RUN_ID's...

Can someone tell me if what I want is even possible?

Thanks

Can someone please help me?

Hey guys, I'm currently testing my application with some scripts I have written. I'm using the following query to list known errors within my application, and the status of the tests that are are...

hey guys, i dont suppose you know how i can go from:

id.............result
----------------------
1..............Pass
1..............Pass
1..............Fail
1..............Pass...

Can anyone help me?

Thanks

hey guys, every day I run a query, that retrieves the past 28 days of results.

so my table looks like:

date..........results
01/01/08...45
01/02/08...23
01/03/08...4
01/04/08...6...

Hey thanks for your help, I just placed all my attributes into the select and the group by, so it's all good (if not quite lengthy!)

lol

Cheers for your help!

So I googled around a little and found out that I needed to cast my 3 details fields to varchars, e.g. cast(bpspA.BPSP_VALUE as varchar(255)) both in the select statement and in the group by clause....

Hey,

Thanks for your reply, but I get the following error:

The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.

Hey guys,

Thanks very much for all your replies, your solutions worked! :D

I was hoping someone could help me further, one query I run is to retrieve car rentals. Lets say, my current retrival...

Hey guys,

I'm working with a database at the minute (not my own), and the two tables are as follows:

----------------------
Customer
----------------------
CustomerID Agent
1 55a
2 97t