if statement 1

[aarellano]

Hello,

I have an asp page, that builds an xml file.

I would like to insert an if statement but it does not seem to be working. I am not really sure what i am doing wrong
any help is always appreciated!!!
Here is my code

mo =  rs("mo")


dddpva = rs("dddpva")
act.WriteLine"<item month=""" & mo & """ value= """ & dddpva & """/>" 

& vbcrlf




' move to the next record
rs.movenext
loop

' All non repetitive xml on bottom goes here
act.WriteLine("</items>")


' close the object (xml)
act.close


' Writes a link to the newly created xml document in the browser
response.write "<a href='rev.xml'>revenue</a> (.xml) has been 

created <br>"
response.write "on  " & now() & "<br>"
%>

I tried to insert

<% if rs("mo").value = 1 then response.write "January"  end if%>

after mo=
but that is not really working

 

[vicvirk]

nix the .value

if rs("mo")[s].value[/s] = 1 then response.write "January"  end if

or, since you already have the value in a variable called "mo" (your first line), just use it

mo =  rs("mo")
if mo = 1 then response.write "January"  end if

--------
GOOGLE is a great resource to find answers to questions like "how do i..."

If you don't know exaclty what you want to do or what to search on, try Google Suggest:

http://www.google.com/webhp?complete=1&hl=en

--------
I have recently been semi-converted to ensuring all my code (well most of it) works in both javascript and non-javasc

 

[aarellano]

that did work on the webpage

Julyrevenue (.xml) has been created

but not in my xml page

'Loop to output all the query results to the xml document
do while not rs.eof


mo =  rs("month")
if mo = 07 then response.write "July" end if

dddpva = rs("dddpva")
act.WriteLine"<item month="""[COLOR=red]&  mo &[/color] """ value= """ & dddpva & """/>" 

& vbcrlf




' move to the next record
rs.movenext
loop

' All non repetitive xml on bottom goes here
act.WriteLine("</items>")


' close the object (xml)
act.close

 

[vicvirk]

if mo = 07 then response.write "July" end if

what do you get if you output the value of "mo" to the screen?

--------
GOOGLE is a great resource to find answers to questions like "how do i..."

If you don't know exaclty what you want to do or what to search on, try Google Suggest:

http://www.google.com/webhp?complete=1&hl=en

--------
I have recently been semi-converted to ensuring all my code (well most of it) works in both javascript and non-javasc

 

[aarellano]

if I try

if mo = 07 then response.write "July" end if

the page loads and it gives me
Julyrevenue (.xml) has been created
on 7/14/2009 11:19:14 AM
it adds the July part next to the revenue

but the xml looks like this

<?xml version="1.0" ?> 
- <items>
  <item month="07" value="260119.84" /> 
  </items>

what I am going for is to get the 07 or any other number to say the Month

 

[aarellano]

I even tried

act.WriteLine"<item month=""" &  <%if mo = 07 then response.write "July" end if %> & """ 

value= """ & dddpva & """/>" & vbcrlf

but I get the below error

Error Type:
Microsoft VBScript compilation (0x800A03EA)
Syntax error
/xmldata/revenue.asp, line 47, column 33
act.WriteLine"<item month=""" & <%if mo = 07 then response.write "July" end if
--------------------------------^

 

[aarellano]

I also tried

mo = if rs("month") = 07 then "July" end if

but get the following error
Error Type:
Microsoft VBScript compilation (0x800A03EA)
Syntax error
/xmldata/revenue.asp, line 42, column 5
mo = if rs("month") = 07 then "July" end if
----^

 

[vicvirk]

your code is all over the place...

first of all you can't do this in ASP

myValue = if condition then a end if

you need to split it up into two statments

if condition then
	myVal = a
end if

or you can write an inline if statement as follows

function iif(c,t,f)
	if c then ' if condition is true
		return t ' return true value
	else 
		return f ' return false value
	end if
end function

and use it as follows

	myVal = iif(condition,truevalue,falsevalue)

also, vbscript has a built in function to get the name of the month, called monthName so

	response.write monthName(07)

would output July

So, with that said (or read), the following

act.WriteLine"<item month=""" &  <%if mo = 07 then response.write "July" end if %> & """ value= """ & dddpva & """/>" & vbcrlf

should work with

act.WriteLine"<item month=""" &  monthName(mo) & """ value= """ & dddpva & """/>" & vbcrlf

if you only want to show items for July, then put an if before it

if mo = 7 then
	act.WriteLine"<item month=""" &  monthName(mo) & """ value= """ & dddpva & """/>" & vbcrlf
end if

--------
GOOGLE is a great resource to find answers to questions like "how do i..."

If you don't know exaclty what you want to do or what to search on, try Google Suggest:

http://www.google.com/webhp?complete=1&hl=en

--------
I have recently been semi-converted to ensuring all my code (well most of it) works in both javascript and non-javasc

 

[aarellano]

that is awsome!!! thank you so very, very much!!! I really appreciate the help. I used monthName that did the trick. But in the process I learned functions!!!!! thanks!!!!
I am building a dashboard in adobe flex and the most inexpensive fastest way to get the data out of my db to xml was asp.

again thank you