Search results

you can't do that. Either put a javascript function for the onClick event or use a .net control button and apply the redirect to it's event handler.

well, theory behind it is. When someone submits a booking, some code fires off to send an email. What you need to tell is what language your website was built in and what type of server it's running on.

Skip ODBC. Open access and create an Access Project. If the database is already created, then create an Access Project Using Existing Data other wise, just make a new Access Project Using New Data. Follow the onscreen prompts for the SQL server infomation and bam..you're done.

That acutally does sound like the more logical way to approach this. Sorry I didn't have a chance to look at your code.. tonights lab was actually quite interactive. Scripting an entire db structure with sprocs and triggers to-boot. Joy.. needless to say it took quite a while and I didn't get a...

I should be able to take a look at this tonight while I'm bored out of my skull in my database class.

lol.. yeah, that can be confusing. Just remember, any time you execute to a new window, you have re-execute after any changes :)

I'll have to set up a test on this one myself. I'm not sure off the top of my head. Are you using an object datasource? or.. how are you binding the data. If you could zip your aspx and vb files for that page, that would be helpful for me to help you.

you need to do Set @LastID=(Select.......) without Set, you will get an error. Though, either way does the same thing. If @LastID is not being populated then there is something else that needs to be addressed. Triggers are a relatively new item on my plate as well. try this ALTER TRIGGER...

Right after the "AS" statement and before BEGIN. When you use DECLARE, it declares a local variable to that procedure just like in any programming environment. In VB we do DIM var.. in sql they do DECLARE var(type).

no, that is ( I believe) a sample app that goes through using the previous concepts in an app so you can see how it all gets put together.

the first video to hit is 2101 under Object Oriented VB.NET.

@@Identity is a bad idea to use here because its' scope is database wide not table specific. Triggers can capture data from the altered row like this for example: DECLARE @LastID int Select @LastID=PositionFillID from Inserted yes, that is literally "inserted" in place of a table name...

1. You could add a check in your code to see if ToDate is null or empty and set the details view mode to edit instead of insert 2. Trigger 3. a variant on 1 really, which checks the ToDate and change the view mode accordingly. I vote #2 with a prompt that it will "close out" the previous one...

Trust me, I've run into this problem a hundred times or more. If you can move to .net 2.0.. do it.. it's like night and day..

put this in a batch file for .NET 2.0 C:\windows\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i for .NET 1.1 do this C:\windows\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe -i then execute the batch file. When you reg .net 2.0 it takes over 1.1 so any sites running 1.1. will...

ok, classes are a programmatic/abstract represention of some object. A person has properties ,procedures, and methods. We have eyes, ears, skin etc.. we have routines (procedures) that we follow dailiy. We have functions that we perform when needed. A person class could represent this. Take a...

what you should do is make a person class (i'm assuming persid is person) with all the attributes that the person table has. SO if your person table has ID, Fname, LName, DOB, SSN etc.. stuff like that, then your class will mirror that using properties. So then what I would do is have a button...

I love short-cuts.. can't help it :)

lets say the url was http://www.someplace.com?id=23 You would do Dim ThisID as integer=request.querystring("id") Then you would pass "ThisID" to your data layer insert method.

start => run TYPE INETMGR (just thought I'd chime in with a shortcut :) )