Search results for query: *

Im doing some asp/java using dreamweaver. nice program but somewhat a inconvienice. i was wondering if anyone knew a way to turn the auto check thing off. the feature that seems to check my code when i switch from page to page and save, as well as the auto tag feature. im used to c++ so i use...

is there any wildcard characters in asp like : if i want to choose a date from the database without concern of year is there a way to look past the year like this say i want all 4/22/ but in the db its always 4/22/2005 or 4/22/2004 i want to pull with with year but without concern in the...

I just recently upgraded from ms access to sql server so there is a few quirks. this one is puzzling me. it begins to enter into a do while section and create an exception error. im not sure why. hopefully a pro may know. If GLRecordCount > 0 Then objRS_UsersGL.MoveFirst...

how can i get an ntext field to display in an asp page. i have this code here and everything dispalys excpet for "detailed_description" which is a ntext type: SQL STATMENT: strTicketUpdate = "SELECT case_id, user_fname, user_lname, wireless_number, urgency, case_type, problem_description...

I was hoping someone could help me with a few SQL statements. The only statements that seems to be giving problems is the MOBILE statements. all of the others work perfect. ive tried to mirror the Mobile statements after the others but it still doesnt seem to work , i keep getting: Microsoft...

Ok this is supposed to be simple but it is not for some reason. i had a post in sql programming that had 37 replies. now im trying here. Im just trying to make a record set with a sql statement against a sql server 2000. here is my error: Microsoft OLE DB Provider for ODBC Drivers error...

Ok, im new to sql. dont have much time to learn until our stuff is migrated and running. its almost done but ive ran into a small issue. ive been looking at this for 2 hours and cant figure it out. whats wrong with this: Dim strIsApproved strIsApproved = "SELECT * FROM InvoiceApproval WHERE...

Im almost done with migrating everything to sql server 2000 with ms access 2002 front end. i ran into one more situation. i have fileup by software artisans used to upload a file in a form. it uploads the file fine. the form grabs all text entered into any field and updates a access database...

Im almost done with migrating everything to sql server 2000 with ms access 2002 front end. i ran into one more situation. i have fileup by software artisans used to upload a file in a form. it uploads the file fine. the form grabs all text entered into any field and updates a access database...

SELECT DISTINCTROW " & service & ".Carrier, " & service & ".Account, " & service & ".Cost_Center, " & service & ".Long_Date, Sum(" & service & ".Total) AS Total, Sum(" & service & ".Actual_Past_Due) AS Actual_Past_Due, Sum(" & service & ".Credit) AS Credit FROM " & service & ", UID_CostCenter...

Im having trouble creating a recordset with ado from a sql database. My connection worked fine , i think it may have to do with the cursor i am using. or i may be going about this the wrong way. can anyone help please. here is my code. i get this error: Microsoft OLE DB Provider for ODBC...

I got this script where i upload a file using sa. everything works perfect excpet i cant get it to check if a file exists and if it does then give it a unique name. this code (depending on how its mix-matched) produces 3 kinds of output. either the filename stays and its always overwritten, the...

I have a form that users put in text, drop down menus, and a file to upload(if they want) the process works fine if the user inputs a file and submits the form, it then updates a database and send the mail with attachment. but when the user doesnt want to upload a file it gets hung up and says...