rita mistry

Greenhorn
+ Follow
since Dec 04, 2001
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by rita mistry

Hi,

I'm having an issue with my view. It is joining to seven tables and as a result it has significantly caused this view to run extremely slowly. I need to use all these tables to retrieve the data but can anyone possibly suggest a way that would speed up running this view.

The view query is as follows:

SELECT TOP (100) PERCENT OMS.ID, OMS.omOrderDate, OMS.omPart, OMS.omDesc, OMS.omOrderNumber, OMS.omCustomerID, OMS.omQuantity,
OMS.omCostPrice, OMS.omSellPrice, OMS.omDistStock, OMS.omDistID, OMS.omPO, OMS.omETA, OMS.omPriority, OMS.omShipdate,
OMS.omConsignment, OMS.omNotes, cust.name, cust.lastName, sup.supplierName, Status.statusName, OMS.omStatusID, prod.Manufacturers,
cust.email, prod.idProduct, OMSps.costPrice, OMSps.stockLevel, OMSps.supplierID, sup2.supplierName AS spSupplierName
FROM OMSystem AS OMS LEFT OUTER JOIN
dbo.suppliers AS sup ON OMS.omDistID = sup.idSupplier INNER JOIN
dbo.customers AS cust ON OMS.omCustomerID = cust.idcustomer INNER JOIN
Status ON OMS.omStatusID = Status.statusID INNER JOIN
dbo.products AS prod ON OMS.omPart = prod.MFID COLLATE Latin1_General_CI_AS LEFT OUTER JOIN
OMS_ProductSupplier AS OMSps ON OMS.omPart = OMSps.partCode LEFT OUTER JOIN
dbo.suppliers AS sup2 ON OMSps.supplierID = sup2.idSupplier
ORDER BY OMS.omOrderNumber DESC


Many thanks Reet
17 years ago
Hi All,
I was just wondering is there a method in JSP which will retrieve the user's IP address. Not the server's IP address but the IP address of the machine they are using.
Any help will be very much appreciated.
Many thanks
Rita.
21 years ago
JSP
Hi All,
Is it at all possible to save a html page as a word document at the click of a button.
Basically the html page will have a form where the user enters their details. However, instead of submitting I want to save that page will all the entered details as a word document by clicking a button.
Is this at all possible?
Any help will be very much appreciated.
Many Thanks,
Rita.
Hi all,
I have developed a Java application and I now want to put it on a web server which has NT4 service pack 6a plus IIS3. I just wanted to know what the requirements were for running a Java interpreter on this type of web server.
Would it be better to have a Linux Server or even a clean Windows 2000 box with IIS5.
Any advice and information would be very much appreciated.
Many Thanks,
Rita.
22 years ago
Thanks Junilu,
Your a Star.
Kind regards,
Rita.
22 years ago
JSP
Hi Junilu,
The items in the company and project lists are outputted from the database. So both the company and project list will grow and shrink but in the case of the company list it won't be that often.
I really appreciate your help. This coding is driving me nuts. Thanks very much.
Rita.
22 years ago
JSP
Thanks for all your help Angela and Junilu.
If I find a way around the problem without having to submit I'll send a post.
Thanks again
Kind regards
Rita.
22 years ago
JSP
Hi Junilu,
Correct me if I am wrong but doesn't the code that you have written above, just store the value in a javascript variable.
I have already obtained the value I need from the form, but I need to now store it in a jsp variable. How do I do this?
If the code above does this then I do apologise.
I'll have a closer look at it.
Kind regards,
Rita.
22 years ago
JSP
Hi Angela,
Yes that is correct.
Let me explain a bit more...
I have a form which has a drop down for a list of companies. Each company has a certain number of projects assigned to it. So what I am trying to do is when the user selects a company, on the projects drop down below a list of all the projects belonging to this particular company will be displayed.
I am using a Javabean to get the items from the database, but I need to pass the information of which company it is in the method parameter.
I don't know how to do this so I thought I could store it in a Javascript var and then pass the value to a jsp var which then means I can use it for the javabean.
I hope this makes sense. If you think there is a better way of doing this then I'm all ears.
Kind Regards,
Rita.
22 years ago
JSP
Hi all,
Can anyone tell me how to pass a value that is stored in a Javascript var to a JSP variable.
I can't use

because the form has not been submitted yet.
Any help will be very much appreciated.
Many Thanks,
Rita.
22 years ago
JSP
Hi all,
Can anyone tell me how to make the submit button a rollover. I have currently changed it to the image that I want it to be by using the following bit of code:

but how do I make it a rollover as well.
Any help will be very much appreciated.
Many Thanks
Rita.
Thanks for all your help guys.
And Steve your information is really helpful. So cheers mate.
Kind Regards,
Rita.
Hi All,
I've set up a form on a jsp page where I have both a text field and two textarea boxes. The only problem is when I have a string of text which includes a single quote e.g.
Why won't this work?
I get an error similar to the following:
java.sql.SQLException: [Microsoft][odbc SQL Server Driver] [SQL Server]Line 1: Incorrect syntax near 'why'.
When I take out the single quote it works. Why is it causing an error?
Any help will be very much appreciated.
Many Thanks
Rita.
Hi Vijay,
I'm using IE 6, which is proabably why mine is working. Sorry I couldn't be of much help.
Rita.
Hi all,
I've been doing some research and you can actually use an inline style:

However, this is just for the newer browsers and it does not work for NN4, so you need to add the width attribute:

Rita.