Search results for query: *

I am using the following cdos code to connect to a remote smtp mail server. it works perfectly when a valid email address is given, if a fake one is given then it errors the page. is their anyway to prevent this? i tried the javascript approach but it still fails sometimes. Const...

Hello, I am using the following connection string on my hosted website plan: dim DbConn Dim dbDir Set dbConn = Server.CreateObject("ADODB.Connection") dbConn.ConnectionTimeout = 0 dbConn.CommandTimeout = 0 DbConn.Open("DRIVER={SQL Server};SERVER=xx.xx.xx;DATABASE=test;UID=tes;pwd=test;") When...

Hello, I am using the following connection string on my hosted website plan: dim DbConn Dim dbDir Set dbConn = Server.CreateObject("ADODB.Connection") dbConn.ConnectionTimeout = 0 dbConn.CommandTimeout = 0 DbConn.Open("DRIVER={SQL Server};SERVER=xx.xx.xx;DATABASE=test;UID=tes;pwd=test;") When...

I am using the following code to set a filter on one of my forms: Private Sub Form_Open(Cancel As Integer) 'Set unbound textbox = to login name. Me.LoginName = strUserName 'Apply filter based on Username field. Me.Filter = "[ReportsTo] = '" & Me.LoginName & "'" Me.FilterOn = True End Sub I...

I have a Windows 2000 server and a static ip address. I use this a web server for a website. I want to install sometime of email program so i can have email addresses for my website. I use CDOS on asp web pages a lot and want to be able to fire off emails from this web server now. i have no...

I have a Windows 2000 server and a static ip address. I use this a web server for a website. I want to install sometime of email program so i can have email addresses for my website. I use CDOS on asp web pages a lot and want to be able to fire off emails from this web server now. i have no...

I have noticed when developing in ACCESS project and SQL server 2000 that I get mixed owners of table and views i create and i am not sure why? i login the sameway for both cases as a user that is the DB_Owner? Can someone clearify this process to me so I can stay consistent. i did not notice...

I am migrating from a shared hosting plan sql server to my own sql server. I am not an admin on the shared plan and cannot use the copy database or transfer database feature....(anyone know a way to bypass that secuirty) Anyways, I have to use access project to import all of the sql objects to...

I have a page that users submit information on. Their are 17 weeks, so i build hyperlinks with this code. </strong><br /> <div align="left"></div> <div align="left"><strong>Weeks: <% for i = 1 to NumberOfWeeks() %> <a href="<% = Request.ServerVariables("SCRIPT_NAME") %>?week=<% = i...

I want to buy sql server for a small website i developed with 3000 customers. they each connect to the db accessing things like customer information and much more. What license would I buy for sql? a processor or can I buy another type ? How does it work, lets say 3000 people hit the db at...

Hello, I have an asp page that talks to my sql server 2000 db. I use it to create accounts on my custom system. I was looking for some ideas on how to re-write this code to put less load on my sql db. Here is how it works: 1) asp form that captures username and password. 2) user clicks submit...

I need to convert a numeric field to char. Numeric field: 1.1 0.5 -1.4 to char 1.1 0.5 -1.4 I keep getting 1.10 0.50 -1.40 using CAST(FIELD AS char(9))??? Any ideas on this?

Is it possible in a view to skip usernames that have a 1 or 0? username id week value jay 1 1 1 jay 1 1 0 jay 1 1 1 jay 1 1 0 jim 1 1 4 jim 1 1 4 jim 1 1 4 jim 1 1 4 jane 2 1 1 jane 2 1 4 jane 2 1 4 jane 2 1 4 For example we would completely skip jay and jane in this example above and not...

I have a view that returns data in the following way: GroupID Username Week W L T TBD 1070 jay 1 10 3 0 12 1070 jay 2 11 3 0 1 1070 john 1 14 2 0 15 1070 john 2 15 1 0 19 There are multiple GroupIDs. Their are multiple Weeks. I need to set a rank in sql by adding another field to this query...

I have a table layed out this way: id username value week 4 john 4 1 5 john 4 1 2 john 4 1 1 john 4 1 3 john 4 1 1 jay 4 1 3 jay 4 1 2 jay 4 1 5 jay 4 1 4 jay 4 1 Is their a way to update the...

I have a table in sql server 2000. it looks like this: id username value week 1 john 0 1 2 john 1 1 3 john 0 1 4 john 1 1 5 john 1 1 6 john 0 1 7 john 1 1 8 john 1 1 9 john 0 1 1 craig 1 1 2 craig 0 1 3 craig 1 1 4 craig 0 1 5 craig 1 1 6 craig 1 1 7 craig 0 1 8 craig 1 1 9 craig 0 1 I...

what is the opposite of top 5? I use top 5 to return 5 out of 16. i need to return the opposite, in this case 11 records. if top 5 of 20, then the 15 records... How would I get this?

I have a view that displays a random selection of ids for each user in my db. id name selection 9 jay 4 5 jay 4 3 jan 4 1 jan 4 4 joe 4 8 joe 4 for each user, i need to update the top 5 ids in the selection column to a random 1 or 0 value. (rand() for each id seed) is...

i have a view that uses top 100% and order by newid(). I need to update this table changing a field to 0. when i try to write an update SP it says i can't because i use the top clause in the view? any way around this?

I have no idea how to do the following and would appreciate help in some way :) I have a view displaying the following: ID Week Wins Difference name 1 1 1 2 jason 1 1 1 5 john 1 1 0 24 jay I want to add a field that ranks the order. I sort...