Search results for query: *

I am actually trying that approach right now. The problem is the .Net program was written by someone else and I'm not that familiar with .Net. I've been searching the internet trying to find code samples to do the same thing I have coded in JavaScript.

I am working on an HTML page that runs JavaScript to retrieve XML data. This data will need to be read by a .Net program for processing and automated alerts. I have code that gets the results from a XML request. I can display the results back on the webpage using the document.write command. If I...

A little more info I have discovered. The validation rounds and excepts -0.4 because it is bound to an integer field in a SQL table. When I change the field type to a float, the validation works as expected and trows back the invalid data error. Any suggestions?

I have a textbox that has a validation rule >=0 AND <=25. The format for the text box is Fixed, Zero decimal places. If I enter -0.4 it rounds the entry to zero instead of displaying the Validation Text that the number is less than zero and is invalid. How do you make the textbox only accept...

Go to Grid properties, Data tab. In the field/expression box, enter something like the following: ="<input type=text size=10 maxlength=10 name=yourName value=[yourField]>"

I have an ASP page that uses several Recordset DTCs connecting to a SQL server. When the SQL server is not avaliable, the page spits out the standard ODBC error messages. How can I trap/catch the ODBC errors when they occur?? (Like when SQL Server is paused and ASP page can't connect)I have...

Thanks for all of your help Sheco! I discovered the problem. The web user I was using to execute the stored proc didn't have permissions to tempdb - that's why you couldn't see the dynamically built columns. I can't believe it was something that simple!!

I don't know how many fields I will have. The recordset is a dynamic crosstab. The 3 fields I talked about were just an example.

Is there a way to pump the results of the EXEC into a temp table directly? Something like SELECT * INTO #temp FROM EXEC (@sql)???

I get an "Object Required" error on this line of code For each fld in rs2.Fields

I have tried the code below: set @tempsql = 'SELECT * INTO #test1 FROM (' + @sql + ') a SELECT * FROM #test1' EXEC (@tempsql) I get the same result. Is there another way to pump the results of the EXEC into a temp table? How would I check for a child recordset?

Background info: I have a main SQL stored procedure that calls the crosstab stored procedure found on the website below: http://www.sqlteam.com/item.asp?ItemID=2955 I return the SQL statement (@sql) from the crosstab stored procedure into the main stored procedure and then run an EXEC (@sql)...

No, what I listed above did not work.

That would work if the bulletin/messagedoc.htm file wasn't overwritten. The user creates a filtered html microsoft word document and saves it to the bullten folder as messagedoc.htm daily. I need a way to call the no right-click script from the messageboard.htm page that creates the frames...

I have a webpage MessageBoard.htm. It contains two frames, a header frame and a main frame. I have a no right-click script in the header section of this page that prevents the user from right-clicking on the header frame. The main frame content MessageDoc.htm is overwritten daily; so, if I add...

The facts: Using Visual Interdev 6.0 on Windows XP Using IIS 5.0 on Windows NT Server for web server (Call it SERVER_X) Developed a Microsoft Access 2002 database in a shared folder on a separate server (Call it SERVER_Y). I am trying to connect to the database using DataEnvironment connection...