Posts
 
Reputation
Joined
Last Seen
Ranked #3K
Strength to Increase Rep
+2
Strength to Decrease Rep
-0
100% Quality Score
Upvotes Received
1
Posts with Upvotes
1
Upvoting Members
1
Downvotes Received
0
Posts with Downvotes
0
Downvoting Members
0
1 Commented Post
2 Endorsements
Ranked #620
~2K People Reached
Member Avatar for alleybye

Hi, I have a problem on getting data from XML file. I am honestly have 0 knowledge on this. Here is the XML data content, i opened the XML file using notepad then pasted here. <?xml version="1.0" encoding="utf-8"?> <?mso-infoPathSolution name="urn:schemas-microsoft-com:office:infopath:Test-Form:-myXSD-2012-09-02T13-13-23" solutionVersion="1.0.0.55" productVersion="14.0.0.0" PIVersion="1.0.0.0" href="http://share.test.com/it/Test%20Form/Forms/template.xsn"?> <?mso-application progid="InfoPath.Document" versionProgid="InfoPath.Document.3"?> <my:myFields xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:pc="http://schemas.microsoft.com/office/infopath/2007/PartnerControls" …

0
132
Member Avatar for alleybye

Hi I have a question, I want to transfer all nodes to a datarow Here is my XML <Employee> <person> <firstName>Jon</firstName> <lastName>Johnson</lastName> <skills>Singing</skills> <skills>Dancing</skills> </person> </Employee> THE HEADER TABLE SHOULD LOOK LIKE THIS WITH RELATION Profile_ID | Firstname | Lastname| 10 | Jon | Johnson | AND THE DETAIL TABLE …

Member Avatar for alleybye
0
296
Member Avatar for alleybye

This is pretty basic guys but i really dont know how to do this. okay. i have to panels on my webpage. what i need to do is i need to hide panel.. i have this [CODE] <script runat = "server"> private void hidepanel() { pnl_Add.Visible = true; pnl_List.Visible = …

Member Avatar for jbisono
0
168
Member Avatar for alleybye

Ive been trying to understand this thing for approximately 1 day, but i cant really get it I'm about to create a report which requires TWO tables. but i forgotten that the datareport.datasource only accepts One command. so ive got the idea of creating a child command and create it …

Member Avatar for AndreRet
0
79
Member Avatar for alleybye

i want to view the number of my expired and non expired stocks, and i cant figure it out. Heres my code. can some please help me? [CODE] Private Sub Form_Load() If rsInventory.RecordCount > 0 Then Do Until rsInventory.EOF If Val(rsInventory("Expiration_Date")) < Date Then expired = expired + 1 rsInventory.MoveNext …

Member Avatar for AndreRet
0
151
Member Avatar for alleybye

please help me! im doing a date comparing project where in i compare the expiration date and the current date i put this on the general [CODE]dim mydate as string[/CODE] then at the formload [CODE]mydate = format(now,"mm/dd/yyyy")[/CODE] and also on my database id format the Expiration field as Date with …

Member Avatar for AndreRet
0
202
Member Avatar for alleybye

[CODE]rsInventory.Open "SELECT Expiration_Date FROM YourTable WHERE Expiration_Date < DateValue(Date)", conn, adOpenStatic, adLockOptimistic[/CODE] what should be the value of that date. if i put date [CODE]rsInventory.Open "SELECT Expiration_Date FROM YourTable WHERE Expiration_Date < Date", conn, adOpenStatic, adLockOptimistic[/CODE] ive got an error 'no value given value given for one or more required …

Member Avatar for AndreRet
0
99
Member Avatar for alleybye

Guys! im doing a search program where in ill just search the name of the product then print it. [CODE] Private Sub txtSearch_Change() rsTransaction.Close rsTransaction.Open "select * from tblTransaction where mid$(Date,3,2) like '" & txtSearch.Text & "%'", con, 3, 2 end sub [/CODE] it is actually doing fine but i …

Member Avatar for debasisdas
0
104
Member Avatar for alleybye

i got this! [CODE]Option Explicit Public con As New ADODB.Connection Public rsTally As New ADODB.Recordset Public Sub Connect() con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Aianski\Desktop\Cliente ko\SGO_Tally.mdb;Persist Security Info=False" rsTally.Open "select * from tbl_Tally ", con, 3, 2 End Sub [/CODE] i think its right. but when i run it i get "syntax …

Member Avatar for AndreRet
0
96
Member Avatar for alleybye

i can trap Number only but i cant trap letter inputs. how to do that? please? example. Enter a letter: 5 "INVALID INPUT! PLEASE ENTER A NUMBER!" please guys?!

Member Avatar for stultuske
0
90
Member Avatar for alleybye

i cant sort it descending? why? please help me!! [code] import java.io.*; import java.util.Arrays; import java.util.Collections; public class alpha { public static void main(String args[]) throws IOException { BufferedReader br = new BufferedReader (new InputStreamReader(System.in)); int num = 0,c,x,a = 0,d,e,letter1,f; String input; System.out.println("\t[WELCOME]"); for (d = 0;d<=2;d++) { System.out.print("How …

Member Avatar for adams161
0
62
Member Avatar for alleybye

I need to do a program that the user will input a letter from alphabet then the program will show the alphabet that starts with the inputted letter. for example Letter: B B C D E F G and so on.. please help me guys.. ive been doing this almost …

Member Avatar for bops
0
562