Search results for query: *

Hi All, My project_1 folder contains all the asp.net/vb.net pages for my website. I created a project_2 folder for a new c# login page. I did this because I needed to add OpenID support (dotNetOpenAuth), couldn't find any vb.net samples, and wasn't up to the task of porting the c# code to...

Hi Everyone, My program is failing so I stepped through my asp/vb.net method and copy/paste/parsed the content below from my string variable into the query window; update data set affiliated_unit = account_code  where company = 'US - Charleston Place Hotel' and account_code in (select...

Hi, My page_1 allows you to look up data with listbox_1. I needed to pass listbox_1.SelectedValue to page_2 so I added an id variable to the page_2 url like page_2.aspx?id = 123.Page_2 loads, sees the variable, sets listbox_2.SelectedValue to the right value, and refreshes the textbox. But...

Hi, I logged in as SA, and created a login and user. I then granted the user rights to execute some stored procedures. This was all done using the dialog boxes. When I returned to the dialog, the execute checkboxes were unchecked. I then wrote a script to do the same thing. The script ran...

Just some random questions... working on my first RoR/SQL Server 2000 app. Do I need to have the database running locally during development? How do I confirm my rails app is connecting to my remote server? How do I handle migrations to a remote server? I need to display relational data in...

Hi, I need to build a list of table and column names using sysObjects and sysColumns, based on the contents of a column. This procedure attempts to loop through each user table's varchar column(s), storing matching values in another table. My problem is I can't figure out how to use...

Hi, This piece of my SQL Server 2000 stored procedure compiles, but gives me this error when I run it? The name 'CREATE TABLE #pivot (property CHAR(5), metric CHAR(25), field1 (INT) NOT NULL, field2 (INT) NOT NULL, field3 (INT) NOT NULL, field4 (INT) NOT NULL, field5 (INT) NOT NULL, field6...

Hi: I'm studying Java in school and need some help. I mention that I'm studying it because I need to write the code myself, and so I guess I'm looking for an explanation more than anything else. My project is to build a stack using an array. If the stack is popped and is empty, then the app...

Hi All: When the SendEmail function is called, nothing happens. Can anyone tell me what's missing? If you haven't already guessed, I'm new to SQL Server (2000) Thanks in advance, Mark Main() ... Call SendEmail(msg) End Function Function SendEmail (msg) Dim iMsg Dim iConf Dim flds...

Hi All: I need to append access data to my sql server table each night. Every month, the data is located in a new network folder, so my DTS package uses an ActiveX script to get the data path from a sql server table. When I test it, it fails on this line: cnn.Open= "Provider=...

HI: I tried a left outer join on three fields, but the results kept excluding a record from the left table. In the query designer, everything looked okay, but I ended up modifying the underlying sql statement as shown The original from clause: FROM ( tblBatch INNER JOIN ( tblTemplate...

Hi: I have Visual SourceSafe 6 set up with DTS packages included. After editing a dts package via Enterprise Manager, how do I update VSS with the new version of the package? Thanks in advance, Mark

I get the following message when I open a solution The project location is not fully trusted by the .NET runtime. This is usually because it is either a network share or mapped to a network share not on the local machine. If the output path is under the project location, your code will not...

Hi: My Access 2003 mdb form's combo uses the following AfterUpdate event to load it's subform with SQL Server 2000 data... Me.SubFormName.Form.RecordSource = vbNullString sql = "SELECT FieldName FROM TableName Where TableNameID = " & me.MainFormCombo_TableNameID rs.Open...

Hi: My access 2003 application uses this ado connection to sql server 2000 (I've removed line continuation characters in this example). cnnString = "Provider = 'Microsoft.Access.OLEDB.10.0'; " "Data Provider = 'SQLOLEDB'; " "Data Source = 'SqlServerName'; "...

Hi: My access 2003 application uses this ado connection to sql server 2000 (I've removed line continuation characters in this example). cnnString = "Provider = 'Microsoft.Access.OLEDB.10.0'; " "Data Provider = 'SQLOLEDB'; " "Data Source = 'SqlServerName'; "...

Hi: Subform 1's delete event needs to refresh the display in subform 2. Can't seem to get it to work. Any ideas? Thanks

Hi: I'm using an ado recordset as my unbound form's recordsource. This is done in the the form's open event. However, when the form is closed and reopened, it's recordsource has been set to a sql statement, which fails since the table the sql references isn't linked in the db. On a related...

My Access03 application (saved in Access00 format) sometimes doesn't save my changes in the code module, even after I've compiled and explicitly hit the save button. If I create a new query then close it without saving the changes, Access 03 doesn't prompt me to save it. I tried...

Hi: My Access 2003 application has a function which updates several sql server 2000 tables within a transaction. I use an ADO connection for all data acess, and the connection's .Execute method for the sql statements. Here's a sample function foo() LoadConnection cnn.BeginTrans...