Search results for query: *

I'm having some difficulty using dde to Excel and the page.setup command with the "scale" paremeter. In the help for page.setup, I can see that the scale parameter can take one of three forms: 1. A number to scale by %, ie 55 = 55% 2. Logical True = fit to 1 by 1 3. 2-dimensional array...

Does anyone have an easy to understand/explain definition of the difference between these two concepts?

Is it possible to perform "looping" outside of the DATA step? For example, do the following 10 times... DATA ... PROC SORT ... PROC FREQ ... DATA ... Just as an example.

This is a very general question. I have a pretty extensive Microsoft SQL background, particularly with writing/designing complex queries. I need to make the leap to SAS and start converting some of my tasks. I'm looking for some good resources, hopefully with examples, to replicate some basic...

Ok, I feel stupid for having to ask this but I can't seem to make it work. I'm following what appears to be a simple example too. SET @v1 = 5; WHILE @v1 > 0 DO SET @v1 = @v1 - 1; END WHILE; I'm betting two errors: 1. Error Code : 1064 You have an error in your SQL syntax; check the manual...

I'm running MySQL version 5.0.16-nt, and according to the documentation, the EXECUTE is a valid GRANT option that I can give. Every time that I try however, I get the following: Error Code : 1144 Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used What...

New to MySQL here and am running version 5.0.16. I've created a simple procedure that I can execute as root. I've created another user that will be used to make my connection from the web. Testing this login, I cannot execute the procedure. I've looked, but can only find ways to grant access...

I've got a page that reads a list of images from a directory and randomly picks one to display in a particular section. Every 5 seconds, it randomly picks a different image to display. I'm using setTimeout to accomplish this. The problem I've got now, is that whenever it fires on the 5 second...

I have an array in my asp code that I want to access in a javascript. I found an example of doing this, but it was for a non-array var. I can access an individual array element via: var myVar = "<%=arrImages(0)%>"; I can also access the "count" for the array, so I can get the entire thing...

Is it possible to do the following? I have an image with say an id="sponsor" on my web page. I need to be able to randomly pick a new image to display in that spot say every 20 seconds. I pick the image from a list of jpg files in the imgSponsors directory on the server. Is it possible for...

Here is the scenario that I have. I've got a table with one row and two cells. In one cell I have an image that will not change. In the other, will be one of several different images. Each image on the right, regardless of which one is displayed at any given time, needs to take up the same...

How do I set the default month to be something other than the current month when I display an asp:calendar? I'm sure it must be possible, just not sure how. Jim

This is not a question of a specific code sample to be reviewed, but rather a question of theory and/or best demonstrated practices when it comes to performing a code review. Currently, these reviews are completed in often less than two hours. What we are finding, is that this is simply not...

I'm trying to modify the SQL statement of an Execute SQL Task using a Dynamic Properties Task. I can successfully modify the SQL statement via a new query in the Dynamic Properties Task, but I can't seem to use the global variable that I've created. For example, if my Dynamic Propterties Query...

I'm trying to find a way to connect to the Crystal iStore from a remote source, namely my Microsoft SQL DB. I'm not sure what driver I need to use to set up the iStore as a remote database. Has anyone ever done this before or even know if its possible. Any help with this would be greatly...

I've just created my first DTS package and an Excel file is my source. Everything loads fine, except for the fact that I end up loading all 65000+ rows that are in the Excel file, even though 99% of these rows are null. How do I set the package to only load the valid rows? TIA, Jim