Re: CSS? - Web Development Discussion Boards

Re: databinding

22-Jun-02 12:28

hmm... theres some code missing... the two lines of code should sit in a datalist...

dates and combo boxes

Shotgun22-Jun-02 4:00

Shotgun

22-Jun-02 4:00

to begin with, still relative newbie to asp here Smile | :)

i'm tryin to make a reminder page, you know, for appoinments, birthdays etc
when the page loads txtRealDate gets the current date how do i read the value of say, txtRealDate and subtract from it the value of a combobox, and show the result in txtWarnDate. any helps really appreciated.

shotgun

Re: dates and combo boxes

Chris Rickard25-Jun-02 15:13

Chris Rickard

25-Jun-02 15:13

1st it depends on if you're using ASP classic or ASP.NET The logic is basically the same but the syntax is way different.

If classic then see DateValue() and DateAdd()

If ASP.NET see System.DateTime
The methods in particular are:
Parse()
Add()
AddDays()
AddHours()
AddMilliseconds()
AddMinutes()
AddMonths()
AddSeconds()
AddTicks()
AddYears()
(Take your pick Smile | :)

)

Looking for ASP contact form

21-Jun-02 19:39

I want to add a contact page to my site that allows users to contact me with questions. The form would ask them to enter there Name/Email Address/Phone Number and Message.

Help. Thank you in advance.

sdukart

Modifying indexsearch.asp

21-Jun-02 19:37

I have been using the sample indexserver.asp and modified it a bit, but I can't seem to get "Summary" to work. What I mean by summary is after the Link/URL/File I want a Summary listed below each result so that a searcher can preview each link before clicking on it.

Help. Thank you in advance.

sdukart

CSS?

Matt Newman21-Jun-02 11:38

Matt Newman

21-Jun-02 11:38

I am not sure which forum CSS questions should go in so I posted it here.

My question is: I have an IFrame and I don't want a border around it. I once saw a CSS style that changed it so the border was the same color as the background.

Thanks if you can help.

- Suspicious | :suss:

Matt Newman / Windows XP Activist Suspicious | :suss:

-Sonork ID: 100.11179

Could you Would you with a goat? - Dr Suess

Re: CSS?

Christopher Lord21-Jun-02 20:05

Christopher Lord

21-Jun-02 20:05

You must apply the CSS to the page IN the iframe, not to the iframe tag.

The main frame in IE is the same way... it has the same border around it as that in an iFrame, but if you change the body tag's 'border' attr, it will take the border off.

Re: CSS?

Matt Newman22-Jun-02 4:46

Matt Newman

22-Jun-02 4:46

Christopher Lord wrote:
You must apply the CSS to the page IN the iframe, not to the iframe tag.

Thats what I was trying to say (obviously didn't do a good job though Smile | :)

)

Thats what I wasn't sure of. Thanks!

- Suspicious | :suss:

Matt Newman / Windows XP Activist Suspicious | :suss:

-Sonork ID: 100.11179

Could you Would you with a goat? - Dr Suess

Re: CSS?

Christopher Lord23-Jun-02 7:47

Christopher Lord

23-Jun-02 7:47

Are you looking for the actual css?
Upon rereading that appears to be your question. Sorry if I misunderstood...

If so your looking for
border:1px solid blue;
applied to the body tag.

Re: CSS?

Matt Newman23-Jun-02 16:55

Matt Newman

23-Jun-02 16:55

Christopher Lord wrote:
Are you looking for the actual css?

I was but a little playing around and I figured it out.

- Suspicious | :suss:

Matt Newman / Windows XP Activist Suspicious | :suss:

-Sonork ID: 100.11179

Could you Would you with a goat? - Dr Suess

Re: CSS?

alex.barylski25-Jun-02 21:55

alex.barylski

25-Jun-02 21:55

Can you not do it with an HTML attribute...?

border="0px"

or something...?

"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr

Re: CSS?

Matt Newman26-Jun-02 6:39

Matt Newman

26-Jun-02 6:39

I tried body border=0 but it works to do something like body style="border:0"

- Suspicious | :suss:

Matt Newman / Windows XP Activist Suspicious | :suss:

-Sonork ID: 100.11179

Could you Would you with a goat? - Dr Suess

Re: CSS?

alex.barylski26-Jun-02 12:21

alex.barylski

26-Jun-02 12:21

body border=0 worked...???

I thought it would be more like

iframe border="0px" or something...*shrugs*

I haven't used iframe in a long time...so i'l quite rusty...

Cheers! Smile | :)

"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr

Re: CSS?

Matt Newman26-Jun-02 16:22

Matt Newman

26-Jun-02 16:22

Hockey wrote:
body border=0 worked...???

Sorry i didnt' explain it well enough. the body border didn't work but the body style="border Blush | :O

" did.

The iframe doesn't have a border it uses the border of the page that is in it.

- Suspicious | :suss:

Matt Newman / Windows XP Activist Suspicious | :suss:

-Sonork ID: 100.11179

Could you Would you with a goat? - Dr Suess

Stored Procedures and ADO

Pradhip20-Jun-02 7:15

Pradhip

20-Jun-02 7:15

Hey folks:

Im new to this .NET development and have not quite yet understood all the magnificent features that .net provides.I am using the ADODB object for database connection and doing things with my SQL server 2000 database.

Now my problem is:-

I have a stored procedure that accepts 8 parameters and runs well in SQL server.But when i try to use it in my ASP page that submits these 8 values according to the WroxBook for ASP i have to definitely define all the 8 parameters using the adodb.command.createParameter.this literally means i need to write the entire ddl for my sql database.

Now is there someway i can by pass this??

Regards
PradS

Why Need Parking lots in Bars when Drunken Driving is Prohibited

Re: Stored Procedures and ADO

Chris Rickard20-Jun-02 9:04

Chris Rickard

20-Jun-02 9:04

You don't have to use ADO parameters. It just makes it a little safer (Type checking, quote catching in strings)

You can use Connection.Execute to execute the stored proc just like in SQL Query analyzer.

Set rst = con.Execute("exec myStored proc " & param1 & "," & param2 & ",'" & VARCHARPAram & "',"...

Re: Stored Procedures and ADO

Not Active21-Jun-02 4:11

Not Active

21-Jun-02 4:11

If you are connecting to a SQL Server database you really should be using the .NET providers for it not ADO

<br />
SqlConnection sqlConn = new SqlConnection("ConnString");<br />
SqlCommand sqlCmd = new SqlCommand("myproc", sqlConn);<br />
sqlCmd.CommandType = Command.StoredProcedure;<br />
sqlCmd.Parameters.Add("@param1", SqlDbType.Int).Value = 1;<br />
sqlCmd.Parameters.Add("@param2", SqlDbType.VarChar).Value = "1";<br />
<br />
sqlConn.Open();<br />
sqlCmd.ExecuteReader();<br />
sqlConn.Close();<br />

Re: Stored Procedures and ADO

Chris Rickard21-Jun-02 4:44

Chris Rickard

21-Jun-02 4:44

Oops, I guess I glossed over the part where he said .NET development. WTF | :WTF:

Printing a query result directly in the local printer ?

psmello20-Jun-02 6:01

psmello

20-Jun-02 6:01

Hi there!

We have a database in a Web-server that give all our offices the information we need.

However, as we are printing in a 40 Column printer some data taken from a web query, I was wondering how to print directly to the local printer.

What I want is:
A) Show the user an HTML page with logos, lay-out and everything he has just consulted
B) Directly to the printer send just part of this query, as we used to do in Basic when assigning content to the printer, not a file, and therefore sending plain data direct to the local printer.

Can anyone help me? I'm a begginner in ASP/ASP.NET but I used Basic in the 80's.

Thanks,

Peter Smile | :)

Peter Berndt de Souza Mello
psmello@akaruvicha.com.py
http://www.akaruvicha.com.py

how to invoke client side Java script?

Marc Clifton20-Jun-02 3:04

Marc Clifton

20-Jun-02 3:04

Can someone give me an example of invoking a client side Java script? I saw another message on this forum about such a thing, to display messages like "You can't do that". Never having done ASP.NET programming before, I'm at a total loss as to where to start with such functionality.

Thanks,

Marc

Re: how to invoke client side Java script?

Christopher Lord23-Jun-02 7:50

Christopher Lord

23-Jun-02 7:50

You'll have to write the script and handle it on the client side using the events supplied by most browsers (onClick, etc)

There may be a fancy way of doing it with the VS.NET IDE but that would just be sugar I have yet to taste.

Re: how to invoke client side Java script?

yesu24-Jun-02 5:08

yesu

24-Jun-02 5:08

hi,
In aspx page add severside button name as

forexample "serverbutton1".

in code behind file aspx.vb

use this

serverbutton1.attributes.add("onclick","test()")

write javascript function "test" in aspx page.
In this way u can invoke both server side and client side events

hope this will help u.
regards
yesu Eek! | :eek:

Help with MS Access write (not an SQL question)

Marc Clifton20-Jun-02 2:55

Marc Clifton

20-Jun-02 2:55

I'm stumped. I can query my Access DB just fine, but even a simple insert, like:

insert into test (test_num) values (123)

fails. I've triple checked my code, which is basically just a cut and paste of the various examples I've found. When I catch the exception at the ExecuteNonQuery call, I get either:

"Operation must be an updateable query"
or
"Syntax error in INSERT INTO statement"

All my statements run just fine directly in Access. I've also gone into IIS and set the priviledges to read/write on the .MDB file. What am I missing?
Thanks,

Marc

Re: Help with MS Access write (not an SQL question)

Richard Deeming20-Jun-02 4:16

Richard Deeming

20-Jun-02 4:16

You need to set the NTFS permissions to allow the annonymous account (either IUSR_MachineName or ASPNET) to read and write to the MDB file and the folder it's stored in. It needs to write to the folder to create the LDB locking file. (You should move the folder outside of your web-site first. )

Re: Help with MS Access write (not an SQL question)

Marc Clifton20-Jun-02 9:57

Marc Clifton

20-Jun-02 9:57

Good grief. That worked. I had set the file permissions in IIS, but not the file permissions in NTFS. After my test query ran, my other query still failed. Turns out you can use the word "PASSWORD" as part of a "where" clause, but it must be a keyword, because you can't use it as part of an "insert" statement. I had to change it to "PASSWRD".

Thank you very much for your help!

Marc
(another bug bites the dust!)

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.